Reporting Services Questions
Why is the first record printed over and over again?
There are two main things to check:
1) Bad Query - Check that your query is returning the correct results. If using SQL Server you can copy and paste your sql into Query Analyzer. One method that works well to check what sql your report is using, is to use SQL Profiler and start a trace to capture all sql before you run your report. You can then copy and paste from there.
2) Aggregate Functions - Sometimes when you add fields to a report you can inadvertently specify the 'First' function which will repeat the same data (the first record) for every record.
Last update: 2007-07-20 18:31
Author: ReportPax Support
Revision: 1.2
Print this record
Send to a friend
Show this as PDF file
Export as XML-File
You can comment on this entry
Comment of air max (2010-02-19 04:16:07):
ml In recent years, with the エアマックス 180's launch, air max 180 Running Shoe,superstar 1 original, マックス狩り the nike ace family also abandoned the Year are named. However, this change has not been recognized by fans of shoes, エアマックス95 generations of market performance can only be described as unsatisfactory. air max 95 entered finally decided to restore the traditional name, launched a renaissance of hope carrying Air Max Shoes 2009, not only follows the 360 air-cushion, but also the introduction of the most popular flywire technology and nike plus ナイキエアマックス95
Comment of mbt (2010-02-19 04:17:44):
ml
With the changing and busy life style, people are more vulnerable to various types of problems like back and muscles problems.不安定靴 Thus, to provide relief to people suffering from such problems many shoe manufacturing companies like 安 mbt and Jump have come out with comfortable range of foot wear and shoes. masai barefoot technology and Jump shoes are designed keeping in mind the urban lifestyle and their everyday use.masai barefoot technology 通販 Both these types of shoes are mostly used by athletes and sports personality for creating better posture and increasing shock absorption for all of the joints.mbt lami Wearing of these shoes provide altogether new experience and assure one to carry one self with style and comfort.mbt lami 通販
Comment of ナイキ エアフォース (2010-02-20 19:39:39):
you can not miss nike air force 1 white. NIKE shoes are wearing so lightly, whether you are travel or exercise, nike air force 1 hiit will be the best choice.rlh
Comment of addidas shoes (2010-02-20 19:40:16):
"The buy air jordan is a product of Nike, Inc. created by designer Bruce Kilgore. This was the first basketball shoe to use the wholesale jordan shoes technology. The name is a reference to air jordans for sale, the plane that carries the President of the United States. The shoes are sold in three different styles. The two most common are low-top and mid-top, while Nike produces a high-top model which is usually harder to find. The mid-top and high-top buy jordan shoes's come with a Velcro-securable strap; the mid-top strap is secured to the shoe while the high-top's strap is movable and removable. Although the shoe comes in many different colors and color schemes, the most common Air Force 1's sold are solid white (often referred to as ""white-on-white"") and solid black colors.jordan shoes for sale"rlh
Comment of エアマックス95 ブラック (2010-02-20 19:40:29):
"The エアマックス メンズ has officially reached Nike Sportswear Icon status and joins the エアマックス グレー, Cortez, Dunk, and エアマックス ブルー. To celebrate theエアマックス レッド status, Nike is planning several エアマックス イエロー specials for the Fall. Included within the lineup are the DQM/Bacon inspired エアマックス パープル Current Huarache, the Hufquake inspiredエアマックス ブラック Current Huarache, the PATTA x Nike Air Maxim 1, the WEST Nike Air Max 1, and the White/Blue OG AM1 inspired Nike Air Maxim. All of these releases, except for the White/Red Nike Air Maxim 1 which is available now, are set to release this Fall. Read on for more. "rlh
Comment of Discount Uggs (2010-02-20 19:40:41):
When you are in the market want to find your own Cheap Uggs and you want to get a basis first, please consider quality! If you keep payments your hard earned money away with those junky New Uggs Discount. When you have too much of a dilemma verdict the seat of Ugg Bailey Button Black at a discounted rate, get quality, your boots will to last longer.The New Uggs Discount woman's boots is designed for durability, comfort and years of wear. Made with top-of-the-line twin-faced sheepskin, this UGG Bags features a removable and replaceable insole that has the ability to keep your feet warm. This Uggs on sale is available in black and sand.rlh
Comment of mbt m.walk 通販 (2010-02-20 19:41:13):
Doctors and physiotherapists recommend mbt 靴 サイズ as an effective therapeutic tool, and top athletes like Benni Raich and Michael von Grünigen use their mbt 値段 as mini training and regeneration centers. Shoes designed byマサイcan have a positive impact in improving posture and gait,マサイシューズ reducing stress on the knees and hips, and even help with joint, ligament and tendon injuriesマサイシューズ 通販rlh
Comment of Buy Ugg Boots (2010-02-20 19:42:03):
"Different gray ugg cardy have different wearing methods. And different people wear different cream ugg cardy. In a word, we should wear black ugg cardy according to our styles and hobbies. In brief, you will be cool and fashionable if you wear your blue ugg cardy which go with your clothes well!Chocolate bailey button ugg" rlh
Comment of ウィメンズ エアマックス (2010-02-21 07:50:33):
ml
In recent years, with the エアマックス 180's launch, air max 180 Running Shoe,superstar 1 original, マックス狩り the nike ace family also abandoned the Year are named. However, this change has not been recognized by fans of shoes, エアマックス95 generations of market performance can only be described as unsatisfactory. air max 95 entered finally decided to restore the traditional name, launched a renaissance of hope carrying Air Max Shoes 2009, not only follows the 360 air-cushion, but also the introduction of the most popular flywire technology and nike plus ナイキエアマックス95
Comment of Nike Kobe IV (2010-02-21 07:54:35):
ml
Many people like to wear sports shoes. At many times, the most important thing is comfortable. Now there are many sports shoes manufactured by many well known shoes manufacturers but the most well known one is Nike Kobe IV
. Lebron James Shoes
are used for casual wear as well as sports wear. Lebron James Shoes
is a hot favorite brand of the young generation and specially those who are sportsperson. nike basketball shoes
are quite hardy so that it can endure the wear and tear that occurs due to the heavy exercise.air max 2009