Details section repeating same data

[Former Member]

I have created a report using Crystal Reports 2008 that uses a group. The details section of the group is repeating the data 11 times when it should only print it out once, before moving on to the next group.

When I copy the SQL query out of Crystal into SQL server the query only returns the info once for each group so why is the report printing it out 11 times for each group?

How can I fix this.

[Former Member · Accepted solution]

Check whether you have any joins between the tables. Also first try to place the fields from only one table and check when the values start repeating by placing the fields from each table.

Regards,

Raghavendra

[Former Member]

You may want to cross verify by using the same sql(that is fetching correct results in the SQL Server) and pasting it into the 'Add Command' dialogue box which is displayed while making a new connection to the report.