Filter sub totals on reports

[dwhite]

I have a report that prints out both detail and summary. I want to eliminate the groups that sub total to 0. I have tried placing an expression in the group footer(txtSubTotal]<>0, but it still picks up those groups. Is there a better way to do this. It would eliminate a lot of wasted paper. Thanks for any help

Dick White

 

[neileg]

Do these total to zero because all the records have a zero value? In which case eliminate these in the query.

If they total to zero because there are positive and negative values, you may have to do some testing before you run the report.

 

[dwhite]

The sub totals net out both negative and positive numbers and I am trying to find where to place the filter to eliminate those groups. I tried the report filter, but it does not recognize the text field which calculates the sub total, so it could be how I reference that control at the report level.

Dick White

 

[neileg]

So could you run a totals query and select only those entities where the total is non-zero. Then bring this into your query on which the report is based as a left join to your main query, thus eliminating the zero sum entities.

I know what I mean but I may not have explained it properly!

 

[dwhite]

Thanks for your help! That worked.

Dick White