Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: GH not printing on each page Post Reply Post New Topic
Author Message
KSAnalyst
Newbie
Newbie
Avatar

Joined: 04 Mar 2008
Location: United States
Online Status: Offline
Posts: 29
Quote KSAnalyst Replybullet Topic: GH not printing on each page
     Posted: 28 Jun 2011 at 5:58am
Hi Crystal Gurus,
 
I work for a mental health department and have been asked to create a report that shows not only the current Practitioner working with the client, but all practitioners working with the client.  It must be grouped by Practitioner so that they can be selected and viewed.  The report works fine except when there is not enough room on the bottom of the page for both GH2 and GF2.  When this happens GH2 prints on one page and does not carry over to the following page where GF2 is displayed.  To me it seems like there should be like a "GH2 continued" from previous page in the header or something.
 
Here is the report structure:
 
GH1- Practitioner
  GH2- Client
     D (Suppressed)
  GF2 (has subreport)(All Practitioners working with client)
GF1- Client count by Practitioner
 
Any ideas would be greatly appreciated.
 
Thank you,
 
Kevin
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Jun 2011 at 6:21am
the GH will only print on each page that has a detail section from that group (assuming you have set the GH to repeat for each page in the group options).
Have you considered not using a subreport and instead linking in yout txteam table and using that as your details?
IP IP Logged
KSAnalyst
Newbie
Newbie
Avatar

Joined: 04 Mar 2008
Location: United States
Online Status: Offline
Posts: 29
Quote KSAnalyst Replybullet Posted: 28 Jun 2011 at 6:46am
Thank you for the quick response.
 
I do have the GH to repeat for each page in the group.
 
The way our system is set up and how we utilize our staff, makes it problematic to use our staff table.  The first report I made used it and we found we were not reporting all available data.
 
Thank you,
 
Kevin
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Jun 2011 at 6:52am
the GH will only repeat if there is a detail row that also prints on that page.
IP IP Logged
KSAnalyst
Newbie
Newbie
Avatar

Joined: 04 Mar 2008
Location: United States
Online Status: Offline
Posts: 29
Quote KSAnalyst Replybullet Posted: 28 Jun 2011 at 6:55am
Thanks again,
 
I appreciate your help.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Jun 2011 at 6:57am
can you write a stored proc or view to get your data?
I usually use this route to avoid sub reports when possible.
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum