Report group suppress duplicate data

Abhilash Thomas
Abhilash Thomas
in AppWorks #1

Hello,

In a report that has got grouping, how can I suppress data field in detail section if the data is duplicated?

Tagged:

Comments

  • Jerome_Pearce
    Jerome_Pearce
    #2

    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 <

  • Abhilash Thomas
    Abhilash Thomas
    #3

    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?

  • Jerome_Pearce
    Jerome_Pearce
    #4

    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.

Categories

image
OpenText CE Products
AppWorks
Gateway & Platform