Suppressing or Hiding Subreport to eliminate white space 1

[kbrown73]

Is there anyway to suppress or hide a subreport to keep it from inserting white space without damaging the integrity of the main report summaries?

I have moved the subreport to a group header section all by itself, shrunk the subreport to .04 and made the header section as small as possible. This works for small date range reports. But when I run a monthly report with LOTS of data, a simple one page report with 30 summary groups turns into a 30 page report.

 

[dgillz]

It sounds like you have this set to "new page after". Format the section the subreport is in and check this.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

 

[kbrown73]

It is not getting a new page it is implementing a .04 "space" where the subreport would normally be inserted. Let me explain further.

I have one report that shows details of jobs completed in a manufacturing environment that details start time, job name, total downtime, total pieces, etc. This is a detailed report that can be ran for any inputed date range. Normally each day for the previous day to determine overall effectiveness of the plant. The subreport displays the downtime reason and time amounts for each job.

I am grouping these by Press (A1, A2, A3, etc), then by Shift (1,2,3), then by Job (603, 608, etc). I am then summarizing and performing calculations on the Press Totals.

This report works flawlessly.

The head honcho wants a "Summary" of this report. One-liners for each press. If one or more of the presses are out of tolerance, he can run the "Detail" report.

On the summary report, I suppressed a lot of the sections (Group Headers, Shift Header, Job Header, Footers, etc) and only want to display the Summary totals.

However, I cannot suppress or hide the header that the subreport is in because it changes my summary totals erronously. For the one-day summary this report is acceptable. There are some spaces between A1, A2, etc. but not bad. But when I run it for a week or a month (more data, more times the subreport has to run) there are MANY spaces...

Clearer? or more Hazy?

 

[crystalreporting]

Nope - no way around it (at least none that I've found). The catch 22 here is that the subreport must be in a non-suppressed section for it to run. If you suppress the section altogether, the subreport doesn't even run, so you don't get values returned from the subreport. It's quite common to want the subreport to run (i.e. to return a shared variable) but not display any values. All you can do, is minimize the amount of space the subreport uses - suppress all of the sections within the subreport itself, then drag the bottom of the subreport up so that it is as small as it can be . I'm guessing you already know this as you mention 1/4" and that's about as small as you can drag it. Can you eliminate the subreport altogether?

Peter Shirley

http://www.linkcorp.com

 

[kbrown73]

Eliminating the subreport would be my next attempt. I thought this would be the case. Thanks for your help....

 

[GMcNamara]

I don't see where you mentioned your version of Crystal, but in CR9, right click on the subreport and select Format Subreport. On the subreport tab, select 'Suppress Blank Subreport'.

In your subreport, make sure that if no records are returned, ALL sections are suppressed. Then in the section of the main report which contains the subreport, select suppress blank section. Now, you should only display a subreport if you have data. No blank spaces should appear in your report.

 

[Alundil]

This is just what I came looking for today. Thank you.