Supressing Group Data

[junbug178]

I have a report which I would like to suppress the following:

Before:

Group 1 Group 2
GF2 ABC 123
GF2 DEF 123
GF2 DEF 456
GF2 GHI 123
GF2 GHI 456
GF2 GHI 789

I would like these results
Group 1 Group 2
GF2 ABC 123
GF2 DEF 123
GF2 456
GF2 GHI 123
GF2 456
GF2 789

Please note Group 1 header is supressed, as I would like the header and on the same rows as Group 2 header.

I hope this makes sense.

Any ideas would be greatly appreciated, TIA.

 

[PatriciaObreja]

Did you try to format field and choose "Suppress if duplicated" from Common tab?



"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium

 

[junbug178]

I tried that first it didn't work, it does nothing everything remains like it was before.

 

[PatriciaObreja]

Create a running total that will count each field in the Details section, evaluate for each record and reset on change of Group1.

Place the running total in Details section of the report.

And then conditionally suppress the header of Group 1:
if {#RTotal0} = 1 then
false
else
true



"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium

 

[junbug178]

That would work but each group contains thousands of records. Thanks for trying though.

 

[PatriciaObreja]

Place the runnning total in any of the group headers.

---------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium

 

[junbug178]

I was just trying that before you posted it works. Thank you very much for your help. You're the best!!!!