Hello everyone -
I created a report (srptLeanIdeaSpecificName) to be used as a subreport. There is a text box with the following on the control line:
=IIf([LeanIdeaNumber] Is Null,"This associate has not been assigned to or a team member of any other lean idea projects."," ")
Using this, if there are records that apply, the records will show up. If there are no records, the "This associate..." line shows up letting the reader know that there are no records that apply. I think this looks better than just showing a blank area.
I have a similar text box in the main report and everything works perfect. When I run srptLeanIdeaSpecificName alone it works perfect too in both print preview and report view.
When I run the main report, if there are records that apply in the subreport it works fine but if there aren't nothing shows up on the subreport (not the "This associate..." line or the headers). If I switch to report view I can see them but not in print preview.
Does anyone know why this is happening?
Side note: Not sure if this matters but I did not set up a parent/child relationship because there really isn't a common field between the two. Both the report and the subreport are based on queries with criteria that the user selects from a form.
I am using Access 2007 but the database is in 2003 format.
Thank you in advance.
I created a report (srptLeanIdeaSpecificName) to be used as a subreport. There is a text box with the following on the control line:
=IIf([LeanIdeaNumber] Is Null,"This associate has not been assigned to or a team member of any other lean idea projects."," ")
Using this, if there are records that apply, the records will show up. If there are no records, the "This associate..." line shows up letting the reader know that there are no records that apply. I think this looks better than just showing a blank area.
I have a similar text box in the main report and everything works perfect. When I run srptLeanIdeaSpecificName alone it works perfect too in both print preview and report view.
When I run the main report, if there are records that apply in the subreport it works fine but if there aren't nothing shows up on the subreport (not the "This associate..." line or the headers). If I switch to report view I can see them but not in print preview.
Does anyone know why this is happening?
Side note: Not sure if this matters but I did not set up a parent/child relationship because there really isn't a common field between the two. Both the report and the subreport are based on queries with criteria that the user selects from a form.
I am using Access 2007 but the database is in 2003 format.
Thank you in advance.
