Suppress in header section of Crystal Report 9

Greeting,

I try to use the Suppress feature in CR9.0 to avoid the duplicate records but failed.  (Format field->common->suppress if duplicate). It is in group header section.

Thanks in advance.

-M
mrongAsked:
Who is Participating?
 
frodomanCommented:
You can suppress using your own conditional suppression formula:

  ( {table.YourGroupingField} = Previous({table.YourGroupingField}) )

Use Section Expert and enter this in the formula button next to the suppress option.
0
 
frodomanCommented:
Suppress if duplicate may not work for this because it looks at the previous record to determine if this one is a duplicate - sounds like you want to suppress based on the previous group, is that correct?
0
 
mrongAuthor Commented:
Yes:-)
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
mrongAuthor Commented:
frodoman,

I tried your suggestions but it didn't work. I still see the duplicates.
Thanks.
0
 
frodomanCommented:
Can you explain how your report is organized and what you are trying to suppress?  Also, why do you have duplicate groups in the first place?
0
 
mrongAuthor Commented:
frodoman,

I have the following fields in the group header. funding_code,bill_date,acct,amount.
Basically, acct and amount will be different and other fields will be the same. the reason I am using grouping because I calculate the sum of amount for the same acct.

Thanks.

-M
0
 
frodomanCommented:
What is it that you want to suppress?
0
 
mrongAuthor Commented:
I want to suppress  funding_code and bill_date.
0
 
frodomanCommented:
Do you just have one grouping in your report?  Also, can you show me a sample of what it looks like now?  Just a quick & dirty text example that you can post here so I can see how the group fields exist...
0
 
mrongAuthor Commented:
Acct_desc      funding_code    bill_date          acct     amount
warehouse     111111         07/19/2007         00121      101
warehouse     111111         07/19/2007         00156       189
warehouse     111111         07/19/2007         08656        65
0
 
mrongAuthor Commented:
frodoman,

My bad, I put the formula into "Suppress if duplicated". It should be in 'Suppress".
how to suppress if it is a text field?

Thanks.
0
 
frodomanCommented:
Rt-click on the field and select 'format'.  On the 'common' tab there is a property for suppress - put the formula in that button.
0
 
mrongAuthor Commented:
I mean the field in hardcoded text.
0
 
mrongAuthor Commented:
I put the following and it returned me error.
( {text6} = Previous({Text6}) )

Thanks.
0
 
frodomanCommented:
You can't suppress hard coded text based on the text itself.  You can however suppress hard coded text based on database fields.  So if you want to suppress the text object, use the same formula that you use to suppress the fields:  ( {table.field} = previous({table.field})

You can use any fields as conditions in your suppression formula - you don't have the use the actual field you want to suppress.
0
 
mrongAuthor Commented:
Thank you frodoman!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.