We help IT Professionals succeed at work.

Does anyone know why a field would show information multilply times in Crystal?

moni81011
moni81011 asked
on
Does anyone know why a field would show information multilply times in Crystal? I have a field in Crystal that I placed in the report and it displays the same info 3 times which is taking a lot of space up on the report.
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2011

Commented:
Did you place it in details section ?
Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
Are you joining tables?

You might have a case with a 1 to many relationship.

mlmcc

Author

Commented:
Yes to both of your questions.  I did place it in the details section and there are tables that are joined together.  Let me take a look at the relationships of the tables.
Thank you.
CERTIFIED EXPERT
Top Expert 2011

Commented:
If the recordset returns 3 records the field will be printed 3 times . Move it to the page or report header to avoid showing it multiple times
CERTIFIED EXPERT
Top Expert 2011

Commented:
... or change your SQL to return one record. Using DISCTINCT is not the best way but usually is the fastest way.

Author

Commented:
The issue is with the joining of the tables.  
Thank you.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.