Sub report with Null values 1

[Moongirl]

I have a sub report that is linked to a main report by an ID field. The sub report is located in the main report details section A. The main report has one group based on ID. The sub report has a shared variable which can be null or hold a value. If it is null I would still like the value of "O" to be passed to the main report. I have the shared variable in the main report located in details section B. My problem is when the subreport returns a null value, the main report variable will equal the previous variable and will not be equal to 0. Any suggestions?

 

[John43]

Try if not isnull
else if isnull

then add whatever you need to check