Suppress header based on conditions suppressing detail section

[Alicia159]

Hello, I hope someone can help me out with an issue that I have been staring at for a while now. I am running Crystal 9 and conecting to a DB2 database.

Basically I am trying to get a report that shows a random 10% of records for each group, so I created a random number field, sorted by that field and had the details section conditionally suppress any record number that was over 10% of the total number of records. My problem is that some groups have details, but there are so few details that the conditional suppression suppresses all of the records. I want to be able to conditionally suppress the header if the details suppression got rid of all the details for that group.

What I have now:

Group 1

Group 2
Record a
Record b

Group 3
Record a
Record b
Record c

Group 4


What I need:

Group 2
Record a
Record b

Group 3
Record a
Record b
Record c.


Thanks in advance for any help!

 

[lbass]

I think you could suppress the header with:

count({table.groupfield},{table.groupfield})/10 < 1

-LB