Suppressed Subreports Exporting Blank Rows to Excel
I have a report that includes a subreport in the group header to calculate a related shared variable value inlcuded as a column in the group footer detail section. I have set the subreport property on the Subreport tab to suppress if blank, and have set the section to be suppressed if blank. The subreport correctly calculates the shared variable value, but when I export, I get 4 blank rows. If I suppress the section containing the subreport direclty, the lines go away but so does my shared variable value.
How can I configure the subreports so that I can generate a clean Excel export.?
Whose last resort is to simply not include the shared variable value obtained from the subreport...