Suppress in header section of Crystal Report 9

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?

Yes:-)

frodoman,

I tried your suggestions but it didn't work. I still see the duplicates.
Thanks.

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?

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

What is it that you want to suppress?

I want to suppress  funding_code and bill_date.

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...

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

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.

Rt-click on the field and select 'format'.  On the 'common' tab there is a property for suppress - put the formula in that button.

I mean the field in hardcoded text.

I put the following and it returned me error.
( {text6} = Previous({Text6}) )

Thanks.

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.

Thank you frodoman!