cookiejar
asked on
Eliminate extra space between subreport and main report page hdr when no data returned in main report
I have subreport in the report footer, when there is not data returned in the main report there is quite a bit a space between the main report page header and the subreport. Is there a way that I can adjust this if no data is returned? See the attachment. Is there a way to test for no data returned in the main report?
whitespace.jpg
whitespace.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Assuming the white space is an empty detail section, you can suppress the detail section using the following formula
isnull({mainfieldinthedeta ils})
To get to the suppress section, right click on the word details, to the left of the report tableau and select section expert. Next to the tick box for supress, click the X-2 button.
isnull({mainfieldinthedeta
To get to the suppress section, right click on the word details, to the left of the report tableau and select section expert. Next to the tick box for supress, click the X-2 button.
To suppress blank sections on main report :
go to section where ur records are placed for main report or the section which causes the gap > right click on section (for ex : details ) > click "section Expert" on fly out menu > you will on /go for "common"tab > choose suppress blank selection.
To suppress blank Sub reports:
1. right click on sub report > "format sub report" > go for "sub report" tab > choose "suppress blank sub report"
or
2. alternatively you can choose suppress blank selection on inside sections of sub report and on main report section where sub report is placed.