Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Duplicate Date is being suppressed

Status
Not open for further replies.

grecon

Technical User
Mar 8, 2007
78
US
I have a report that shows:

account# customer address city state zip contact invoice# total

For some reason the customer, city and state columns are suppressing duplicates. I have checked and I do not have the Suppress Duplicate oe Suppress checked in the format field. Any ideas why this is happening or where I should look??

Here is my report:


This is how the data looks

 
Sorry I meant DUPLICATE DATA IS BEING SUPPRESSED
 
Is this your report?

Is the data in one section or several?

Sections can be suppresed: right-click on the left-hand margin where it shows the section names. Choose 'Section Expert' and see what may be checked.

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP [yinyang]
 
Check in the x+2 formula areas (the x+2 box will appear red if it contains a formula) for 'suppress if duplicated' and 'suppress'. If there is a conditional formula, it will suppress when the criteria are met even if the box is not checked.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top