Crystal Reports Hide All Detail with Subreport

[CubanFrapAddict]

I have a CR2008 report that the detail uses a subreport. I have the subreport hidden already, but now I want to hide ALL of the detail so I show only my aggregates as rows of data. This will be exported so drill-down is not an option.

Here's why:
I have agent data, which report to supervisors, which report to group managers, which report to site managers.

I want to see the totals at the supervisor level as rows of data, grouped by group manager, which of course will then be grouped by site manager, and then the corporate total will be last.


Will there be any unforseen problems?

 

[lbass]

Put the subreport in a separate detail section and then suppress or hide the other detail section.

-LB

 

[CubanFrapAddict]

I've tried that and I've tried compressing the detail a to it's smallest height but it still displays 2+ inches of blank space between group totals.

It does this:

supervisor 1 totals ......
<blank space>
<blank space>
<blank space>
supervisor 2 totals ......
etc
What I need is:

supervisor 1 totals ......
supervisor 2 totals ......
.....
supervisor 15 totals......


Will there be any unforseen problems?

 

[lbass]

Detail_a (if that's where your sub is) should entirely disappear if you do the following: suppress all sections WITHIN the subreport; in the main report->format subreport->subreport tab->check "suppress blank subreport". Remove the borders on the sub. Go into the section expert->detail_a and check "suppress blank section".

You should also take a look in design mode of both the sub and the main report to see if you have sections, i.e., unused white space, that should be suppressed, and whether you have minimized the height of sections to match the height of objects in that section.

-LB

 

[CubanFrapAddict]

I get the same thing, I can suppress the subreport like you said and detail a, until I try to hide or suppress detail b. When I hide detail b, it looks like I want but the subreport doesn't run, if I suppress detail b, I get blank rows.


Will there be any unforseen problems?

 

[lbass]

In what section is the subreport located? Both hiding and suppressing would make a subreport NOT run--if the subreport was in that section, but I thought your sub was in detail_a?

If you suppress or hide a section you would not get any blank rows for that section--so you must be seeing another blank section--what does it say in the gray area to the left of the row you are describing as blank?

-LB

 

[CubanFrapAddict]

The subreport is located in detail a.
If I hide detail b, it also hides detail a, and looks like I want but having detail a hidden stops the subreport from running.
If I suppress detail b, detail a remains un-suppressed and therefore the blank rows. Obviously if I suppress detail a, the subreport won't run. I have it set to suppress blank rows, but it doesn't.


Will there be any unforseen problems?

 

[lbass]

Please reread my earlier post about how to make a section containing only a subreport disappear. You actually can just eliminate the detail_b section. Once you have the inserted summaries, you know longer need the detail fields.

-LB