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 Print this record
Send to a friend Send to a friend
Show this as PDF file Show this as PDF file
Export as XML-File Export as XML-File

Please rate this entry:

Average rating: 0 out of 5 (0 Votes )

completely useless 1 2 3 4 5 most valuable

You can comment on this entry