Skip to Content
author's profile photo Former Member
Former Member

Details section repeating same data

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 15, 2009 at 04:30 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 15, 2009 at 05:28 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.