Page Headers in a Subreport?

building reports crystal reports
1

I just found out that Page Headers are not available in Subreports. Unfortunately, I have a subreport with more than one page of information. Has anyone encountered this situation before? Is there a work-around to get column headers to show up on the second page of a subreport?

I’m still wondering why the Page Headers are removed from subreports to begin with…

Thanks for any suggestions.

tamiller73 :us: (BOB member since 2005-11-18)

2

I am not sure on why they have removed the Page header in Sub report.
But the alternate option for displaying the column header in 2nd page is to create a dummy group by and change the Group properties to repeat the header in all pages.

Ex: If your query is select col1, col2,… from table1
then change your query to select 1 dumgrp, col1, col2,… from table1
and group the data base on dumgrp. Change the settings for this group.

Hope this helps.

venkaran (BOB member since 2006-08-08)

3

Or you could create extra Page Header section in Main report to be replica of your subreport… then in the section expert (of this newly created Page Header section), suppress this section by enter formula like

PageNumber = 1 or PageNumber = 2

Note ** This will work fine if your subreport start from page 2, when preview the report.

WizardofCR (BOB member since 2006-08-10)

4

Here is the recommended crystal way to show page headers in subreports. Please note, I have tried this and it came from knowledge base article c2014229

Enjoy,
Sylvia Reynolds

KBase Article ID:c2005103
Article refers to:Crystal Reports 7
Symptom

Since subreports are objects in the Main Report, they do not contain Page Headers.

How can you create a fake page header for subreports?

Resolution
To create a fake page header for subreports, use the following steps:

  1. In the subreport, create a formula:
    @FakePageHeader
    //name of formula
    WhileReadingRecords;
    " "

  2. Go to the ‘Insert’ menu and click ‘Group’. Select the @FakePageHeader formula.

  3. Select the ‘Repeat Group Header on Each New Page’ option, and click ‘OK’.
    This inserts a new group at the lowest, or innermost, grouping level. You will need to move this group to the highest, or outermost, grouping level.

  4. Go to ‘Report’ menu and click ‘Group Expert’. Use the up arrow to move this newest group up to the top of the list.

  5. Move all the headers that you would like repeated into this Header for the @FakePageHeader group.
    More Information

For information on creating fake page footers in a subreport, refer to knowledge base article c2014229 on our support site at:
http://support.businessobjects.com/search
Training

sylviajuttareynolds (BOB member since 2006-09-05)