I have a report that takes a value from the sub report and adds to it
Ex:
[Report1Subtotal]+[Subreport1Subtotal]
The problem is that if the subreport does not have any value for that client it will give an error
I have tried using an iif statement like
iif([Subreport1Subtotal] is null, 0, [Subreport1Subtotal])
but that doesnt work either.
Is there a way to make this work or will i have to enter a record in the Subreport with a zero vaue?
Thaks