suppress rows in a report (1 Viewer)

[anski]

i want the report not to show data with zero balances. example: if my report has 10 line items and 3 of these line items have 0 balances, then the report should only show the 7 items that do not have 0 balances. (the report should use up 7 lines / rows only.)

kindly see the attached report for a better understanding of what i want to achieve. thanks.

 

[stopher]

Just base your report on a query where you filter out the records with zero balanaces (or use the filtering option in the report itself).

balance<>0

hth
Chris

 

[anski]

the figures that you see in the report are TOTALS already (group footer). i tried using the field in the filter option where field <> 0 but every time i run the report, it looks for that field (like it wants me to enter a value as a parameter).

 

[stopher]

Create an aggregate query that totals by group. And then join this with your original query via the group and filter on group balance total <>0.