INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

Thanks so much for having a place for us propeller heads to hang out and chat.

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Reporting Solutions > Business Objects: Crystal Reports 4 Other topics Forum

Duplicate Date is being suppressed

Read More Threads Like This One

grecon (TechnicalUser)

20 Aug 12 15:44

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:

http://www.mediafire.com/view/?tyx80tlpafp10k8

This is how the data looks

http://www.mediafire.com/view/?3qs2cyoaf9lb4be

grecon (TechnicalUser)

20 Aug 12 15:55

Sorry I meant DUPLICATE DATA IS BEING SUPPRESSED

Madawc (Programmer)

22 Aug 12 6:27

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

lbass (TechnicalUser)

25 Aug 12 8:23

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

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Business Objects: Crystal Reports 4 Other topics