subreport / detail report - filtering help required 1

[spl1]

Hi
I have created a subreport which details pension amount being paid (currency)(if nothing paid then reports 0).
The main report is grouped by person name and payroll number and the subreport is linked via the payroll number. The subreport does not hold person name.

The report declares all names and the correct amount of pension being paid.
However, I have been asked to split the report to show 0 amount being paid by person.
I have brought the amount of pension being paid into the main report using shared currencyvar. This does not show in sort expert to define it to declare formula =0

I've tried via formulas that if pension is <>0 then dont show persons name - but this left a blank line in the report

I've tried declaring 0 currency on the subreport only and this then makes the main report declare all with 0 pension even though I know they have a value - ie the main report still brings back the persons name regardless.

Any idea's how I can filter the main report

 

[lbass]

Are you saying you ONLY want to display those with 0 pension payments? It sounds like you were able to do that, and the only problem was a blank line--what report section was blank? It sounds like you might have suppressed the name instead of the section containing the name. Try going into the section expert and using the variable to suppress the section containing the name. This assumes the sub is in a section above the name section, e.g., in GH1a, while the name is in GH1b. Let me know if you need to know how to make GH1a disappear also.

-LB