Subreport height

[Former Member]

Hello, I am using Crtstal Reports ver. 8.5. Many of my reports use subreports simply to calculate extra information & put them into variables to bring back into the main report. Therefore all groups in the subreport are supressed.My problem is that in the main report, the subreport's height(right clicked on the subreport,"object size and position") is always a minimum of 0.040. Any height lower than 0.040 dos not get saved with the report. Therefore when users run the report, they get extra blank lines which is the subreport's line.I can manually reduce the height of these subreports & then print for the user eliminating the blank line that the subreport gives but Crystal does not save the new height. This is very frustrating as more & more reports now have subreports. The users do not have the capability to manually modify the height of the subreports as we only have 1 Crystal Reports license. Is thare any option anywhere in Crystal that would allow me to change the minimum height of a subreport or allow me to save the height change that is less than 0.040.

Thank you

[Former Member · Accepted solution]

Hi,

This functionality is by design of the crystal report you can minimize the height of the sub report to a certain level so that the sub report can execute and pass the values to the main report if no values are printed in the sub report then use the option . Rightclick on subreport > format sub report > sub report tab. select the option suppress if blank report.

Regards,

Vinay

[Former Member]

Hi Vinay, I didn' t see a suppress if report blank , I have only have a suppress checkbox in the subreport tab of the format subreports option. The suppress didn't do anything, when I run the report I still get about 10 - 15 blank lines where the subreport is, I believe that these lines correspond to the number of times the subreport is called or the number of records read by the main report.

p.s. In the subreport itself, all groups are suppressed.

Thanks for responding

[Former Member]

Hi Ted,

Thanks for your reply, are the detail section and report header sections are also suppressed in the sub report. And also uncheck the can grow option for the sub report and make the sub report as small as it can

Regards,

Vinay.

[Former Member]

Hi Vinay, all the groups in the subreport are suppressed, the "can grow" checkbox was already un selected and as for the report height which I believe is the key, it can be changed to 0.001 which solves my extra line problem but this does not get saved, crystal by default saves the height as 0.040 in "Object size and position" option. Then when the users run the report they get about 10-15 extra blank lines between each displayed entry because of the default 0.040 height.

Thanks

regards

Ted

[Former Member]

Mark the section in which the subreport(s) is located "underlay following sections"

[Former Member]

Hi James, I just tried that & it still gives me those extra blank lines.

Thanks

Regards

Ted