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