How to remove duplicated data from the details section

[maas]

Hi,

I need your help and assistant in removing the duplicated deal_no from the details sections in my report. My report structure is as follows:

#Group header 1: Type
#Group Header 2: Deal_no
Details: {Deal_no}, {Amount}
#Group Footer : Deal_no
#Group Footer 2: Type

Example Data:
Type A
12 1000
14 2000
156 300

Type B
12 1000
658 3000

Now the {Deal_no} = 12 is shown twice and I want only to show it once.

I tried in the details and in the Suppress to keep the formula {deal_no} = previous {deal_no}, but it didn't work. So how can I solve the issue.

 

[tomcat24]

Try formula {deal_no} <> previous {deal_no} or use SELECT DISTINCT in your PROC.

 

[kray4660]

The other way is move your detail objects to the GF of Deal_no and suppress the detail.