Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Suppress in header section of Crystal Report 9

Posted on 2007-07-23
16
Medium Priority
?
881 Views
Last Modified: 2012-05-05
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
0
Comment
Question by:mrong
  • 9
  • 7
16 Comments
 
LVL 42

Expert Comment

by:frodoman
ID: 19547718
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
 

Author Comment

by:mrong
ID: 19547816
Yes:-)
0
 
LVL 42

Accepted Solution

by:
frodoman earned 200 total points
ID: 19547843
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
Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

 

Author Comment

by:mrong
ID: 19547918
frodoman,

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

Expert Comment

by:frodoman
ID: 19548208
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
 

Author Comment

by:mrong
ID: 19548375
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
 
LVL 42

Expert Comment

by:frodoman
ID: 19548435
What is it that you want to suppress?
0
 

Author Comment

by:mrong
ID: 19548500
I want to suppress  funding_code and bill_date.
0
 
LVL 42

Expert Comment

by:frodoman
ID: 19548578
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
 

Author Comment

by:mrong
ID: 19548663
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
 

Author Comment

by:mrong
ID: 19549310
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
 
LVL 42

Expert Comment

by:frodoman
ID: 19549378
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
 

Author Comment

by:mrong
ID: 19549395
I mean the field in hardcoded text.
0
 

Author Comment

by:mrong
ID: 19549415
I put the following and it returned me error.
( {text6} = Previous({Text6}) )

Thanks.
0
 
LVL 42

Expert Comment

by:frodoman
ID: 19549472
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
 

Author Comment

by:mrong
ID: 19549692
Thank you frodoman!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Screencast - Getting to Know the Pipeline
Suggested Courses
Course of the Month20 days, 23 hours left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question