J
James
I have a complicated report that has many groups and two subreports.
Basically it is the merging of different reports grouped for each client,
rather like a letter with a following info sheet. Not all letters have info
sheets, and letters can be longer than one page, and there can be more than
one info sheet per letter, and info sheets are always one page long! Also
footers need to be switched on and off depending what the page is. All is
going well until the subreport (info sheet) has no record, does not exist.
I say no records because the "No Data" coding is never triggered as the
subreport does hold data, just not for this client. So what I get is a blank
page. I have tried making it invisible, but Access is very dumb here since if
you print something invisible on a page you get a page with nothing on it,
rather than ignoring it! "On Retreat" is never triggered as this group
forces a break before section. If "On Format" of the group header that holds
this subreport checks to see if anything is there it does not work on isnull
- there just is nothing for it to pick up on, and the code skips it! Odd but
hovering over the code in break mode produces nothing at all.
Am I missing something really basic? Please has anyone got the answer?
Thanks.
Basically it is the merging of different reports grouped for each client,
rather like a letter with a following info sheet. Not all letters have info
sheets, and letters can be longer than one page, and there can be more than
one info sheet per letter, and info sheets are always one page long! Also
footers need to be switched on and off depending what the page is. All is
going well until the subreport (info sheet) has no record, does not exist.
I say no records because the "No Data" coding is never triggered as the
subreport does hold data, just not for this client. So what I get is a blank
page. I have tried making it invisible, but Access is very dumb here since if
you print something invisible on a page you get a page with nothing on it,
rather than ignoring it! "On Retreat" is never triggered as this group
forces a break before section. If "On Format" of the group header that holds
this subreport checks to see if anything is there it does not work on isnull
- there just is nothing for it to pick up on, and the code skips it! Odd but
hovering over the code in break mode produces nothing at all.
Am I missing something really basic? Please has anyone got the answer?
Thanks.