Crystalkeen logo; we offer Crystal reports viewers and schedulers
Crystalkeen header image 3
Crystalkeen header image 5

Crystal Reports Tools: Improve Performance While Saving Time and Money

Best sellers:



CR Schedulers
CR Viewers
DataBase Tools
Mail UFLs


About us

Contact Us
cViewSUITE Ppt


on Steroids

Crystal Reports: Remove Duplicate Values

One common report layout is a series of columns across the page to display some important data.

If you want to format the report so that duplicated values are not repeated down the page, use the field formatting option.

If it is in the Details section, you can:

  1. Right click on the field, and select the “Format Field” menu.

  2. Tick the Box that says: Suppress if duplicated

If it is in the Group Header section, you need to use Conditional Suppress: Click on the X-2 button beside the Suppress option on the Object Formatting and enter a formula of

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

If it is in the Group Footer section, sadly this same logic does not work. We will need a formula with variables to apply this to the group footer.

Now, this brings an important question to mind. Exactly why are you using a reporting system to display data? A properly designed report will provide the answers users seek, deriving those answers from the data. That's really the difference between data and information. And your report should provide information.

If your report is merely a fancy way of presenting raw data, or if users want data instead of your report, there is something wrong with your report.

To fix this problem, ask users what business questions they need answered. They should not be spending their time manipulating data. They should have their business questions answered by your report, so they can do the work they are paid to do.

It may be true, however, that your relational database -based reporting system can't provide the analysis abilities your users need. If that is the case, consider implementing an OLAP system.

All the time users spend playing with spreadsheets is not going to provide answers your reporting system can't provide, as spreadsheets are a step down from relational databases. Users probably don't realize they are going backwards, not forwards.

It's also important to ensure the data you do have are accurate.



This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.