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

Group header did show on second page 1

Status
Not open for further replies.

Nice99

Technical User
Feb 13, 2011
17
US
Hello All,

I have report that contain two sub reports.
Using Crystal Reports 2008, Oracle 10G database

The mail report and two sub reports all have multiple groups and calculations for all category totals, summaries, they have different titles, the link between them only for the record ID witch make sure the data selected from same month. It should be totally different reports but customer want all put together as one report witch titled as part 3, part 4, part 5.
I tried use page header but couldn’t find condition to suppress for different report titles, so I put report titles in group header for mail report and sub reports, and checked ‘Repeat Group header on Each Page’, the issues is some page only show group foot and did not show report title which is group header if there is no detail record on second page, is there any one can help?

Example:
Group header: report title one part 3
Detail: records
Group foot: summaries

Thanks,

Nice99
 
Please identify the report sections in which you have placed the subreports. Also explain whether you have checked "new page before" on the sections containing the subs.

-LB
 
Hi lbass,

Thank you very much for your help! I have sub reports placed in Report foot b and Report foot c, yes I did checked "new page before" on these two sections. Report foot a have grand totals for main report.

Thanks again!

Nice99

 
Update,

Sorry, the subject posted was wrong, it should be "Group header did not show on second page" I will deleted and post again.

Thanks,

Nice99

 
No, please don't post again.

I think you should instead create three page headers a,b,c in the main report to use for your labels, and then conditionally suppress them. Create formulas like this:

//{@falsemain} to be placed in the report header:
whileprintingrecords;
booleanvar flagmain := false;

//{@truemain} to be placed in the report footer_b section:
whileprintingrecords;
booleanvar flagmain := true;

//{@falsesub1} to be placed in the report footer_b:
whileprintingrecords;
booleanvar flagsub1 := false;

//{@truesub1} to be placed in the report header section and in the report footer_c sections:
whileprintingrecords;
booleanvar flagsub1 := true;

//{@falsesub2} to be placed in the report footer_c:
whileprintingrecords;
booleanvar flagsub2 := false;

//{@truesub2} to be placed in the report header section:
whileprintingrecords;
booleanvar flagsub2 := true;

Then go into the section expert and format each section like this:

//pageheader_a->suppress->x+2:
whileprintingrecords;
booleanvar flagmain;
flagmain = true; //note no colon

////pageheader_b->suppress->x+2:
whileprintingrecords;
booleanvar flagsub1;
flagsub1 = true; //note no colon

////pageheader_c->suppress->x+2:
whileprintingrecords;
booleanvar flagsub2;
flagsub2 = true; //note no colon

-LB
 
ibass,

The formulas work great, thank you so much for your help!

Nice99
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top