I've created a report which has [account number] & [processing amount], however all those accounts without processing amount are suppressed automatically.
I tryed to create a outer join relation, but it doesnt work...The null value rows are still not showing...
Anybody can help here? (I wont be able to adjust the FM model, so prefer some solution within rs itself)
You can relatively easily solve this with a union
union1: [account_number] [processing amount]
union2: [account_number] 0
Use the result set in the report (make sure you total the measure) and group by account_number.
The result will show ALL account_numbers, with 0 where no processing amount exists