Hello,
In a report that has got grouping, how can I suppress data field in detail section if the data is duplicated?
If there is duplicate data in rows, you can remove the duplicates in the SQL for the Business Object. The standard method is to use:
"Select distinct x,y,z ... "
A more efficient way, if you are happy with it, is to use a Group By clause and add all the fields selected.
Some more tips on making pretty and functional reports in our > Video Review of Metastorm BPM 9 <
I was talking about the 'Suppress if duplicate' option available in crystal report. Certain fields I want to show only for the first record in the detail section, for the remaining records those fields should not display data. Can we do this in Metastorm reports?
Yes, you can use a group header. There is no need to suppress data, just put the fields you want in the header in a header section. summary totals can be added to a footer (or a header) as well.
My demo will explain much better than I can.
