Fenriswulf
Technical User
Hi,
I have a report that needs to run 2 subreports for every entry in a table (Employer) in order to ensure that results are being returned for every Employer.
I have based the main report off the Employer table grouping on Employer.Employer_name with the two subreports in Details A & Details B sections. Because not all employers will have results returned for one or both of the subreports, I was attempting to use dummy subreports to conditionally suppress the subreports that contain no results.
The problem is that despite the suppression, I'm still getting blank spaces appearing in the report. My testing is showing that the dummy subreports are returning the values necessary to conditionally suppress the reports, and when manually suppressing the sections containing the subreports each Group Header starts on a new page (and yes, I have checked and rechecked to make sure the New Page After/Before boxes are unticked).
The report layout is as follows:
------------------------------------------------
|GH 1A | Dummy Subreport1 Dummy Subreport2
------------------------------------------------
|GH 1B | GROUP NAME
------------------------------------------------
|Details A | SUBREPORT1
------------------------------------------------
|Details B | SUBREPORT2
------------------------------------------------
I have a few things left to try with this, but I was hoping that someone may be able to provide some insight.
Thanks in Advance,
Jason Street
I have a report that needs to run 2 subreports for every entry in a table (Employer) in order to ensure that results are being returned for every Employer.
I have based the main report off the Employer table grouping on Employer.Employer_name with the two subreports in Details A & Details B sections. Because not all employers will have results returned for one or both of the subreports, I was attempting to use dummy subreports to conditionally suppress the subreports that contain no results.
The problem is that despite the suppression, I'm still getting blank spaces appearing in the report. My testing is showing that the dummy subreports are returning the values necessary to conditionally suppress the reports, and when manually suppressing the sections containing the subreports each Group Header starts on a new page (and yes, I have checked and rechecked to make sure the New Page After/Before boxes are unticked).
The report layout is as follows:
------------------------------------------------
|GH 1A | Dummy Subreport1 Dummy Subreport2
------------------------------------------------
|GH 1B | GROUP NAME
------------------------------------------------
|Details A | SUBREPORT1
------------------------------------------------
|Details B | SUBREPORT2
------------------------------------------------
I have a few things left to try with this, but I was hoping that someone may be able to provide some insight.
Thanks in Advance,
Jason Street