Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help with displaying Group Headers in subreports 1

Status
Not open for further replies.

Alex1971

Programmer
Mar 16, 2004
2
US
I am working on this problem which I hope someone can help me with.
I have 4 separate reports. Currently reports don't have any parameters. My client would like to pass Client_ID paramet (one record at a time) to the first 3 reports and than pass it to the 4th report and also pass date parameter to it as well. The way it needs to work is for example: pass 1st Client_ID to the first report process it than pass that same 1st Client_ID to the second report and so on. Than after all 4 reports process, than pass 2nd Client_ID to the first report and so on in the loop.
Each report has Page Header, Group Header, Details, Group Footer and Page Footer.
I've already started working with this by crating a new report and inserting group by Client_ID and created 4 group sections (Group 1, 1a,1b and 1c) in which I placed each of the reports mentioned above by creating subreports.
The problem is that each of the reports doesn't have the same number of pages. It migh have different number of pages depending on the data that is associated with that particular Client_ID.
Each report has a different page header which needs to be displayed for each of these reports on each page.
I tried to use suggestions from Crystal Reports help site about creating fake report header but it doesn't help much becuase each report is located in the group sub-section. So for example when you print 10 different pages for one Client_ID for the first report than it only displays group header on the first page and not on the subsequented ones.

Sorry about the long post but I wanted to be as descriptive as possble so you can get a clear idea of what I am trying to accomplish. I am ready to give up on this one but I would appreciate it if someone can help me out with this or tell me that its impossible to accomplish it. I am under a deadline so I would appreciate it if someone can answer asap.

Many thanks,
Alex1971
 
I forgot to mention that I am using Crystal Report 8.5 and Access 2000.

Thank you,
Alex1971
 
You should be creating a fake group header within each subreport. First, you would create a formula where all records will meet the criterion, as in:

{table.id} > 0

Insert a group on this formula and check "Repeat group header on each page."

Now you can place your subreport "page header" fields in the fake group header and they will appear on each page of the subreport.

-LB
 
Hi,

I'm also having some problems with fake page header.
In my main report i have a page header and i group my report into "Job#" & "Customer".
At the group footer of "Job#", i have a subreport.
I have created page header for my subreport.
How do i get the page header from my sub report to prints only when there is records? At the same time the page header from the main report is to be supressed.
I hope somebody can understand my problem.
Please Advice.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top