Microsoft SQL Server Reporting Services and Visual Studio 2005/2008 ReportViewer FAQ

Reporting Services Questions

ID #1010

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

Comment of coach outlet (2010-03-16 17:27:28):
Purchase Oakley Sunglasses from online Oakley store,Discount Oakley Sunglassesare offered now.

Comment of louboutin (2010-03-17 00:34:10):
ugg boots christian louboutin louboutin christian louboutin louboutin shoes christian louboutin boots lv handbags mbt shoes christian louboutin jimmy choo cheap jimmy choo discount jimmy choo jimmy choo sale jimmy choo shoes jimmy choo boots Manolo Blahnik cheap Manolo Blahnik discount Manolo Blahnik Manolo Blahnik sale Manolo Blahnik shoes Manolo Blahnik boots Yves saint Laurent cheap Yves saint Laurent discount Yves saint Laurent Yves saint Laurent sale Yves saint Laurent pumps Yves saint Laurent boots Ed Hardy cheap Ed Hardy discount Ed Hardy Ed Hardy sale Ed Hardy boots Balmain Shoes cheap Balmain Shoes discount Balmain Shoes Balmain Shoes sale Balmain boots Alexander McQueen cheap Alexander McQueen discount Alexander McQueen Alexander McQueen sale Alexander McQueen shoes Alexander McQueen pumps gucci shoes cheap Gucci shoes discount gucci shoes gucci Shoes sale gucci shoes UGG boots cheap UGG boots discount UGG boots UGG boots sale UGG australia Tory Burch Shoes cheap Tory Burch Shoes discount Tory Burch Shoes Tory Burch Shoes sale Tory Burch Shoes Bottega Veneta cheap Bottega Veneta discount Bottega Veneta Bottega Veneta sale Bottega Veneta Lanvin Shoes cheap Lanvin Shoes discount Lanvin Shoes Lanvin Shoes sale Lanvin boots Herve Leger Dress cheap Herve Leger Dress discount Herve Leger Dress Herve Leger Dress sale Herve Leger MBT Shoes cheap MBT Shoes discount MBT Shoes MBT Shoes MBT Shoes

Comment of Vibram FiveFingers (2010-05-16 19:08:23):
Coach Bags and Chanel Bags are two combinations of Vibram FiveFingers style and fashion. They are always be together in Louis Vuitton Bags and Coach Wallets. That’s why never leave women in Chanel Wallets store, they might buy any Louis Vuitton Wallets they see. Even though, there are some Coach Bags on sale who are fussy about their Chanel Bags on sale, and unsatisfied with Louis Vuitton Bags on sale they have. In every moment of time, Prada Bags play significant role in women’s world. The Prada Bags on sale come in an exciting array of colors UGG Hazel Sandals and designs. So, women will never UGG Sandals get bored with the UGG Boots on sale they are going to buy, such as UGG Boots outlet and UGG Classic Tall Boots. Here are some ghd Straighteners collections that some ghd Hair Straighteners have. For those who likes to go to the ballroom might have collection of dance ghd Straighteners on sale. Meanwhile, those who like ghd Straighteners outlet might own bowling MBT Shoes and walking MBT Shoes on sale, and athletic MBT Shoes outlet. Women are asked to be careful when buying sports Chanel Jewelry because it play no small Tiffany Jewelry in the performance of the sportsman. Take a walk though the Chanel Jewelry on sale store. Above all that, when you are doing other Tiffany Jewelry on sale there are different women’s Chanel Jewelry outlet for various occasions. Let’s say you can have the classic Tiffany Jewelry outlet or neutral shaded pump for formal wear, strappy sandals or sexy Ray Ban Sunglasses for the evening out, casual Ray Ban Sunglasses on sale that go best with your jeans and beach Ray Ban Sunglasses outlet.

Comment of timberland rolltop boots (2010-06-17 04:20:52):
That must be the story of innumerable timberland 6 boots couples,and the pattern of life it offers has a homely grace.It reminds you of a timberland 6 inch boots placid rivulet,meandering smoothly through green pastures and shaded by pleasant timberland mens custom trees,till at last it falls into the vastly sea; but the sea is so calm,so silent,so indifferent,timberland men chukka that you are troubled suddenly by a vague uneasiness. Perhaps it is only by a kink in my timberland womens premium boots nature, strong in me even in those timberland mens chukka days,that I felt in such an existence,the share of the great majority,something mens timberland boots amiss.I recognized its social value.I saw its ordered happiness,but a womens timberland boot fever in my blood asked for a wilder course.There seemed to me something alarming in such easy delights.In my heart was desire cheap timberland boots to live more dangerously.I was not unprepared for jagged rocks and treacherous,shoals it I could only have timberland eye boat change-change and the excitement of unforeseen.

Comment of sfsdfg (2010-06-20 19:03:48):
I’m very interested in your article, and I suggest you to browse some online stores to find something different. Such as: chi hair straightener and ghd hair straightner, vibram five fingers, ed hardy t shirts. I believe you would like the air jordans shoes, replica louis vuitton bags. What’s more, the nfl jerseys, replica rolex watches, cheap ugg boots, chi flat iron t shirt would give you an unifque life.

Comment of vibram five fingers (2010-06-20 19:09:29):
Thanks for sharing your article. As a sports fan I adore all kinds of sports equipments. I've got cheap jordan shoes、 vibram five fingers and p90x. I think edhardy　are the coolest t-shirts in the world!

Comment of 123 (2010-06-21 05:13:29):
I’m very interested in your article, and I suggest you to browse some online stores to find something different. Such as: chi hair straightener and ghd hair straightner, vibram five fingers, ed hardy t shirts. I believe you would like the air jordans shoes, replica louis vuitton bags. What’s more, the nfl jerseys, replica rolex watches, cheap ugg boots, chi flat iron t shirt would give you an unifque life.

Comment of cheap nfl jerseys (2010-06-24 02:16:13):
The Atlanta Falcons [url=http://www.jerseystown.com/][b]nfl jerseys[/b][/url] Matt Ryan Premier jersey is made of heavier fabric, with polyester diamond weave mesh. This team- colored jersey displays the embroidered NFL? Equipment patch at the point on the v-neck collar and a team specific jock tag at the lower left front above the hem. The officially licensed Premier [url=http://www.jerseystown.com/][b]cheap nfl jerseys[/b][/url] is designed with the sewn on jerseys single-layer tackle twill team graphics at the chest, back, sleeves and shoulders.[url=http://www.jerseystown.com/nba-jerseys-c-63.html][b]NBA Jerseys[/b][/url]. High quality products and services, competitive prices and prompt delivery are our company's goal, we are looking forward to starting long term cooperation with you in the near future. Please feel free to contact us for more details.

Comment of new 95 airmax (2010-06-28 00:26:43):
Be sure that you have never had any regrets in your nike air 2010 life which only lasts for a few decades. Laugh or cry as you like, and it is meaningless to oppress yourself. Be sure that you have never had any airmax 95 nike regrets in your life which only lasts for a few decades. Laugh or cry as you like, and it is meaningless to oppress yourself.Be sure that you have never had any nike max air regrets in your life which only lasts for a few decades. Laugh or cry as you like, and it is meaningless to oppress nike airmax 2010 yourself.Apart from tears, only time could wear everything away. While feeling is being processed by nike max air time, conflicts would be reconciled as time goes by, just like a cup of airmax 95 blue tea that is being continuously diluted.Penitence is something that enervates our nike shoes children spirit, causing a greater loss than loss itself and making a good words !

Comment of new 95 airmax (2010-06-28 00:27:11):
Be sure that you have never had any regrets in your nike air 2010 life which only lasts for a few decades. Laugh or cry as you like, and it is meaningless to oppress yourself. Be sure that you have never had any airmax 95 nike regrets in your life which only lasts for a few decades. Laugh or cry as you like, and it is meaningless to oppress yourself.Be sure that you have never had any nike max air regrets in your life which only lasts for a few decades. Laugh or cry as you like, and it is meaningless to oppress nike airmax 2010 yourself.Apart from tears, only time could wear everything away. While feeling is being processed by nike max air time, conflicts would be reconciled as time goes by, just like a cup of airmax 95 blue tea that is being continuously diluted.Penitence is something that enervates our nike shoes children spirit, causing a greater loss than loss itself and making a good words !

Comment of new 95 airmax (2010-06-28 00:31:57):
Be sure that you have never had any regrets in your nike air 2010 life which only lasts for a few decades. Laugh or cry as you like, and it is meaningless to oppress yourself. Be sure that you have never had any airmax 95 nike regrets in your life which only lasts for a few decades. Laugh or cry as you like, and it is meaningless to oppress yourself.Be sure that you have never had any nike max air regrets in your life which only lasts for a few decades. Laugh or cry as you like, and it is meaningless to oppress nike airmax 2010 yourself.Apart from tears, only time could wear everything away. While feeling is being processed by nike max air time, conflicts would be reconciled as time goes by, just like a cup of airmax 95 blue tea that is being continuously diluted.Penitence is something that enervates our nike shoes children spirit, causing a greater loss than loss itself and making a good words !

Comment of new 95 airmax (2010-06-28 00:37:20):
Be sure that you have never had any regrets in your nike air 2010 life which only lasts for a few decades. Laugh or cry as you like, and it is meaningless to oppress yourself. Be sure that you have never had any airmax 95 nike regrets in your life which only lasts for a few decades. Laugh or cry as you like, and it is meaningless to oppress yourself.Be sure that you have never had any nike max air regrets in your life which only lasts for a few decades. Laugh or cry as you like, and it is meaningless to oppress nike airmax 2010 yourself.Apart from tears, only time could wear everything away. While feeling is being processed by nike max air time, conflicts would be reconciled as time goes by, just like a cup of airmax 95 blue tea that is being continuously diluted.Penitence is something that enervates our nike shoes children spirit, causing a greater loss than loss itself and making a good words !

Comment of hobo bags (2010-07-06 18:16:32):
Dazzling hobo bags are One of Most Attractive Fashion Direction In Fall and Winter This Year

Comment of timberland 6 inch (2010-07-10 02:17:18):
There were timberland 6 inch sensitivity and a beauty to her that have nothing to do with timberland 6 inch boots looks. She was one to be listened to, whose words were so easy to take to timberland boots sale heart.I used to find notes left in the collection basket, beautiful timberland boots outlet notes about my homilies and about the writer's black timberland boots thoughts on the daily scriptural readings. The person who penned the notes mens timberland boots would add reflections to my thoughts and would always include some timberland pro boots quotes from poets and mystics he or she had white timberland boots read and remembered and loved. The notes fascinated black timberland shoes uk me. Here was someone immersed in a search for truth and beauty. Words had been cheap timberland boots treasured, words that were beautiful. And I felt as if the words timberland waterproof boots somehow delighted in being discovered, for they were obviously very generous to the as yet anonymous timberland work boots writer of the notes. And now this person was in turn learning the secret of sharing them. Beauty so shines when given away. The only truth that exists timberland hiking boots is, in that sense, free.

Comment of timberland 6 inch (2010-07-10 02:24:27):
There were timberland 6 inch sensitivity and a beauty to her that have nothing to do with timberland 6 inch boots looks. She was one to be listened to, whose words were so easy to take to timberland boots sale heart.I used to find notes left in the collection basket, beautiful timberland boots outlet notes about my homilies and about the writer's black timberland boots thoughts on the daily scriptural readings. The person who penned the notes mens timberland boots would add reflections to my thoughts and would always include some timberland pro boots quotes from poets and mystics he or she had white timberland boots read and remembered and loved. The notes fascinated black timberland shoes uk me. Here was someone immersed in a search for truth and beauty. Words had been cheap timberland boots treasured, words that were beautiful. And I felt as if the words timberland waterproof boots somehow delighted in being discovered, for they were obviously very generous to the as yet anonymous timberland work boots writer of the notes. And now this person was in turn learning the secret of sharing them. Beauty so shines when given away. The only truth that exists timberland hiking boots is, in that sense, free.

Comment of timberland 6 inch (2010-07-16 00:34:59):
One Sunday womens timberland boots morning, I was told that someone was waiting for me in timberland 6 boots office. The young person who answered the rectory timberland boots door said that it was "the woman who said she left all the notes." When I saw her mens timberland boots I was shocked, since I immediately recognized her from church but had no timberland boots outlet idea that it was she who wrote the notes. She was sitting in a chair in timberland roll top boots office with her hands folded in her lap. Her head was bowed and when she raised white timberland boots it to look at me, she could barely smile without pain. Her face was disfigured, and timberland classic boat skin so tight from surgical procedures that smiling or laughing was very difficult for her timberland kids waterproof boots . She had suffered terribly from treatment to remove the growths timberland shoes that had so marred her face. We chatted for a while that Sunday morning and agreed to meet for timberland womens premium boots lunch later that week. As it turned out we went to lunch several timberland boots women times, and she always wore a hat during the meal. I think that treatments of some timberland shoe company sort had caused a lot of her hair to fall out. We shared things about our lives. I told her about my women timberland shoes schooling and growing up. She told me that she had worked for timberland 6 inch years for an insurance company. She never mentioned family, and I did not ask. I have thought about her timberland mens custom often over the years and how she struggled in a society that places an incredible premium on looks, class, wealth and all the other fineries of life. She suffered from a disfigurement that cannot be made to look attractive. I know that her condition black timberland boots hurt her deeply.

Comment of Frank (2010-07-19 02:28:45):
Gucci handbag does not only is a symbol of taste and fashion, but also is a symbol of social status and recognition. And it is the reason that Gucci has swept the world. How amazing for you to have one or more Gucci.What is important,brand handbag are available at a lower price now. I hope our new brand handbag will meet with your favorite items below. As you see above Gucci bags,which are good enough for you to have one.We also offer all kinds of wholesale designer handbag!

Comment of Gucci (2010-07-27 22:44:35):
Customer ServiceGucci chinagucci handbags Huge Selection outlet store worldwide Low Customer ServiceGucci bags Gucci Fine Jewelry At Here outlet store

Comment of jordan shoes eleven (2010-07-29 00:47:01):
Abundance is a life cheap nike jordan on sale style, a way of living your life. It isnt something jordan shoes eleven you buy now and then or pull down from the official nike jordan shoes cupboard, dust off and use once or twice, and then air jordans 1 return to the cupboard.Abundance is a philosophy; it appears in your air jordans six rings physiology, your value system, and carries its own jordan retro eights set of beliefs. You walk with it, sleep with it, bath with it, feel buy jordan elevens with it, and need to maintain and take care of it as well.Abundance doesnt always men orginialjordan retro elevens require money. Many people live with all that jordan retro elevens money can buy yet live empty inside. Abundance begins inside with some air jordan 13 main self-ingredients, like love, care, kindness and gentleness, thoughtfulness and jordan retro 14 compassion. Abundance is a state of being. It radiates air jordan 4 outward. It shines like the sun among the many moons in the nike jordans world.Being from the brightness of abundance doesnt allow the new air jordans darkness to appear or be in the path unless a choice to allow authentic nike air jordan shoes it to. The true state of abundance doesnt have men's air jordan on sale room for lies or games normally played. The jordan shoes clearance space is too full of abundance. This may be a challenge because we still need to jordan on sale free shipping shine for other to see.

Comment of timberland boots (2010-07-30 02:45:24):
It is a good timberland 6 inch boots thing that the God Who made us is not impatient with people like me with my timberland shoe company orchid. He lovingly thinks about us all the time timberland boots and he even temporarily gave up His heavenly home and his timberland traditional handsewn hold on diety to die for the sins of timberland mens custom world nearly 2,000 years ago. His death back then covered the sins of every cheap timberland boots person who will ever live. He then rose to life after three mens timberland chukka days and ever since has wanted us to accept His gracious act by loving Him and also those around us. When we do this, we will see people in a totally different timberland womens premium boots light — one that redefines what it means to be ugly or different or weird or strange. Instead, we see people with ugly timberland shoes store problems in whom God is working so they can bloom beautifully — just like I now see in my orchids whether they are “lumps” or blossoms! On a certain timberland work shoes day at a certain hour, we will pull into the station. Bands will be playing and flags waving. Once we get there, so many wonderful dreams will come true and the pieces of our timberland wheat shoes lives will fit together like a completed jigsaw puzzle. How restlessly we pace the aisles, *ing the minutes for timberland for you loitering --waiting, waiting, waiting for the station.

Navigation

TOP 10

The five questions posted most recently:

Reporting Services Questions

Why is the first record printed over and over again?