I have a report that the data collected is driven by the subreport. The report looks like this
detail A is the subreport
Detail B is the data to be displayed based on the subreport returning a value of 1 any other result is to be ignored I can suppress this based on subreport <>1
Group footer with a bunch of text fields in it. I can suppress this on subreport <>1
IF the value of the subreport is not equal to 1 then the record is ignored no page generated at all. Here is my problem when I run the report for a given date range I am getting blank pages for the records that do not equate to 1. Any ideas?
detail A is the subreport
Detail B is the data to be displayed based on the subreport returning a value of 1 any other result is to be ignored I can suppress this based on subreport <>1
Group footer with a bunch of text fields in it. I can suppress this on subreport <>1
IF the value of the subreport is not equal to 1 then the record is ignored no page generated at all. Here is my problem when I run the report for a given date range I am getting blank pages for the records that do not equate to 1. Any ideas?