Suppressing Records in Detail Section if Less than 4 1

[dmt4cats]

I am using Seagate Crystal Reports, Version 7.5. I have a report with multiple rows for each ticket. I have grouped the report by ticket number and done a running total to show the number of rows for each ticket. My customer only wants to see the tickets that have 4 or more rows. Is there a way for me to show all the entries for those that have 4 or more entries and suppress those that have 1, 2 or 3 rows. I can suppress all the running total entries for rows 1, 2 and 3, but I need those first three rows of data on the tickets that have 4 or more entries.

Thank you for any help you can provide.

 

[dgillz]

1 - dump the running total.

2 - Create a simple formula that tests a mandatory field:
If not IsNull({AnyRequiredField}) then 1 else 0

3 - Sum this formula by ticket number.

4 - Write a group selection formula:
Sum({AnyRequiredField},{TicketNo})>4

let me know if you have any questions.
Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[dmt4cats]

It worked. Thank you very much. I really appreciate your help.