C
cityblm.is
Subject is unclear, I know, but here's what I am working with in my
report. I am working on a small database for general fiscal
information for a building that holds different types of events.
My main report has three sub reports, in columns, one for each fiscal
year the business has been operating. In my database, I have four
unique event types. The event type is linked in the reports so there
are four pages to the report. Every fiscal year to date, there have
been events of each type, except for FY1 where there was no events of
type "3" (Other). So, there are four pages to the report, but on page
three, FY1 does not show anything - no zeros, it's just blank.
I've tried working with HasData - but that's a problem because the
subreport does have data because the other event types have data for
that fiscal year. I've also tried working with null and nz, but
obviously that doesn't matter because the controls do not exist on
that page of the report.
Any ideas?
Thank you very much.
report. I am working on a small database for general fiscal
information for a building that holds different types of events.
My main report has three sub reports, in columns, one for each fiscal
year the business has been operating. In my database, I have four
unique event types. The event type is linked in the reports so there
are four pages to the report. Every fiscal year to date, there have
been events of each type, except for FY1 where there was no events of
type "3" (Other). So, there are four pages to the report, but on page
three, FY1 does not show anything - no zeros, it's just blank.
I've tried working with HasData - but that's a problem because the
subreport does have data because the other event types have data for
that fiscal year. I've also tried working with null and nz, but
obviously that doesn't matter because the controls do not exist on
that page of the report.
Any ideas?
Thank you very much.