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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SubReport PageHeaders

Status
Not open for further replies.

neomorpheus

Programmer
Mar 9, 2001
47
US
I have been having trouble with this for quite some time. Any help would be appreciated.

I have a five reports created individually...Each accessing a separate stored procedure in the database but require the same parameters. Each report contains its own set of Report Headers, Page Headers, footers etc.

REQUEST-My Customer now wants an option where he can view the data of all these five reports simultaneuosly in one report.

My Solution- I created a blank report and inserted each of the five reports into separate Report Footers - A to D. When I pass the parameters as required, I get all the data.

My Problem- My sub reports which have anywhere from 1 to 15 pages dont have a page header anymore. Reports with 1 page data are okay, but reports which have more than a page are the ones that gimme this problem.

I found some info on the Seagate site and here too that subreports are treated as objects on a main report and that creating a fake header is the solution. But in my case of five subreports, how can i go about creating fake headers (OR) How can I have the page headers of my individual reports show up when added as a subreport to a main report??

HELP!! HELP!!

Would really appreciate.
Thanks
 
Based on Crystal 7.0

i) Create a formula in the sub report, say @FakeHeader, and add following

WhileReadingRecords;
""

ii) Create a group in the subreport based on @FakeHeader. Place this group at the top of the list.

iii) Place all fields etc.. that you want to appear in the Page Header into the GroupHeader.

iv) Repeat for each subreport

Hope this helps. It worked for me! NB :- apparently you cannot get a Page Footer into the subreport using this method.

Cheers

Jim Brock


 
Jim:

Your solution was offered at the Seagate site too. Unfortunately, it doesnt seem to work on CR 8.0 which I use. Any suggestions for Ver. 8.0??

Thanks
 
Sorry missed something off!

When you create the Group(part ii) you must set the "repeat group header on each new page" to True....



Jim Brock


 
Jim:

I did set the Repeat Group Header to TRUE. But it doesnt seem to work on Crystal Ver.8.0.
 
I tried this trick from the Crystal decisions site and it often times works but I seem to have a problem with this working if I am printing information in the group footer of group 2 (the non-fake header group...). It wants to print the "fake" page header everytime group 2 changes, not just at the top of every new page. Any ideas???
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top