Supressing Details Section with formula

[Bobbs23]

I am trying to suppress the details section of my report only if my group total is less than or equal to one. I am not objective to suppressing the group as well when this condition is true. Any help would be appreciative.

Thanks

 

[lbass]

Go to the section expert (format->section)->details->suppress->x+2 and enter:

sum({table.amt},{table.groupfield}) <= 1

This formula will also work to suppress the group header and footer, if you wish. Highlight each section and add this into the suppression formula area. You must substitute the correct table and field names, of course.

-LB

 

[Bobbs23]

Thanks LB, and I understand where you are coming from, but I want to condition the suppressed sections by a running total and not a field or table. Currently, I can get it to suppress correctly by going to the section expert and putting in the following:

{running_total} < 2

This works and doesn't work, becasue it doesn't bring back all the information when the statement is false. For instance, if the result is 3 records, two will show for that group.

 

[lbass]

Running totals are not likely to be the answer in this situation. Someone might be able to help if you describe your report structure in more detail, provide some sample data, and explain why you need to use running totals instead of regular summaries. There might be an alternative approach that will work for you.

-LB