Subreport null data

  • Thread starter Thread starter andrew3254
  • Start date Start date
A

andrew3254

Hi

I have a report with multiple subreports on it, one for each month.

The subreports are linked to the main report via a project ID, and some
projects dont have data entered for that month. The missing data is blank
but I want to show 0s. I have tried

Nz([Int Forecast], 0)

and

IIf(HasData, [Int Forecast], 0)

and neither work.

Does anyone have any ideas?
 
Unfortunately no. I also tried using VBA in the NoData section in the module
to see if I can change the values in the text boxes. That didn't work
either. Its something to do with their not being data for a specific project
for the appropriate month. All the data management functions that deal with
this dont seem to be working.
--
Thank you




Golfinray said:
Try this - it should be close. IIf([int forecast]>0,[int forecast],0)

andrew3254 said:
Hi

I have a report with multiple subreports on it, one for each month.

The subreports are linked to the main report via a project ID, and some
projects dont have data entered for that month. The missing data is blank
but I want to show 0s. I have tried

Nz([Int Forecast], 0)

and

IIf(HasData, [Int Forecast], 0)

and neither work.

Does anyone have any ideas?
Click to expand...
Click to expand...
 
Back
Top