Display Group Header only if there are Details 1

[marc79]

Hi,
I'm new to Crystal Reports but have been assigned to implement the following requirement. The report lists Supervisors (Group Header) and their Employees (Detail). Now, the client DOESN'T want the following scenario:
Having the Supervisor at the end of the page without any Employees, since those are listed on the next page.

What they want is that the Supervisor will be printed on the next page together with the Employees. However, we don't want to "keep group together" for the whole report per se (only for the above scenario).

How do i go about implementing this?

Appreciate any help i can get. Thanks.

 

[lbass]

Please see thread767-947312 for one solution.

-LB

 

[marc79]

Thanks for the link lbass. Shall try that out.

 

[marc79]

I have a follow up question. How can i do this in a subreport? I noticed that the logic you suggested, will put a reset formula in the page header. But there are no page headers in sub reports right? Is there a way to get around this? I was thinking of placing the reset formula in the page header of the main report and sharing the linecounter variable, but it didn't work.

Any suggestions?

 

[lbass]

Create a fake page header in the subreport. First create a formula that includes all records in the sub, e.g.,

whilereadingrecords;
1

Insert a group on this, and set it to "repeat group header on each page". Remove the groupname and use this new header for your reset formula.

-LB

 

[marc79]

Thanks lbass. Was able to fix my problem using your suggestion.