Change page header for different pages. 1

[maggi]

Hi I have a 4 line page header on my report. The first page of my report displays a crosstab report and 2nd page displays the detail records, crosstab again and so on.

I want to display a different 3rd line on my page header for the crosstab page and different 3rd line on my detail records pages.
How can I do this?

 

[lbass]

I think you could do the following. This assumes that your crosstab is in a group header and that you have "new page before" set for the group header. Create two formulas:

//{@false} to be placed in the detail section:
whileprintingrecords;
booleanvar flag := false;

//{@true} to be placed in the group header section:
whileprintingrecords;
booleanvar flag := true;

Then go to the section expert and insert a second page header section. Use the page header_a section for the crosstab page and the other for the details page. Then select page header_a->suppress->x+2 and enter:

whileprintingrecords;
booleanvar flag;
flag = false; //note no colon

Then format page header_b in the suppression formula area with:

whileprintingrecords;
booleanvar flag;
flag = true; //note no colon

-LB

 

[maggi]

Thanks!

 

[maggi]

Hi lbass,

I just realized that I need a 3rd page header for the report footer data. How should I take care of this?

Thanks

 

[lbass]

You can create the same formulas with a different variable name, e.g., flag2. Place {@false2} in the report header, and {@true2} in the report footer. Then use a suppression formula of:

whileprintingrecords;
booleanvar flag2;
flag2 = false;

This assumes that you have "new page before" set for the report footer.

-LB

 

[maggi]

I put @false2 in the report header, @true2 in the report footer and supression formula in page header c. But I see page header c along with page header b on my page.

 

[lbass]

On what page are you seeing both headers? You should also place {@false} (from the first set of formulas) in the group footer.

-LB

 

[maggi]

I am seeing both the page headers on the report footer pages. I did place {@false} in the report group footer but still same results.

 

[lbass]

In the GROUP footer, not the report footer. Also you would need a new page before on the report footer.

-LB

 

[maggi]

I have 3 group footer's. I tried placing {@flase} in all 3 but still same results.

 

[lbass]

Are you sure you set up the suppression formula in the section expert with a colon in:

flag2 = false

I can't really visualize your layout, so you will have to provide a layout of your report and indicate where you are placing each formula and then also where you have the suppression formulas. I'm assuming you renamed the variable to flag2 in all the new formulas.

Also show the content of the flag formulas by name.

-LB

 

[maggi]

Here is my layout

RH1 - {@false2}
PHa - supression formula
whileprintingrecords;
booleanvar flag;
flag = false;

PHb - supression formula
whileprintingrecords;
booleanvar flag;
flag = true;

PHc - supression formula
whileprintingrecords;
booleanvar flag2;
flag2 = false;

GH1
GH2
GH3 - {@true} - New Page Before, New Page After
Details - {@false}
GF3 - {@true} - New Page Before
GF2
GF1
RFa - {@true2} - New Page Before
RFb - {@true2} - New Page Before
-----------------------------------------------------
{@true} - whileprintingrecords;
booleanvar flag := true;

{@true2} - whileprintingrecords;
booleanvar flag2 := true;

{@false} - whileprintingrecords;
booleanvar flag := false;

{@false2} - whileprintingrecords;
booleanvar flag2 := false;

 

[lbass]

First, I don't think you need a new page before on GF#3.

Change the conditional suppression formulas in the section expert->suppress->x+2 to the following:

//for PH_a:
whileprintingrecords;
booleanvar flag;
booleanvar flag2;

flag = false or
flag2 = true

//for PH_b:
whileprintingrecords;
booleanvar flag;
booleanvar flag2;

flag = true or
flag2 = true

-LB

 

[maggi]

That works just fine.. Thanks

 

[maggi]

Hi lbass,

I just noticed something strange happening with my report. I am displaying page header c for my report footer data. And before the report footer data is displayed on a new page I display my subreport, which uses page header b. If there is not data in the subreport I supress it but in that case it displays page header b for my report footer data. If there is data in the subreport it works fine. Any suggestions on how to fix this?

Thanks,

Maggi

 

[lbass]

I'm not sure. How are you suppressing the subreport? Are you suppressing the section, or what? What formula are you using? I can't tell what section you have the subreport in, so please identify. Also, just to clarify, I thought you wanted page header_c to display for both report footer sections, is that correct?

-LB

 

[maggi]

My subreport is in my group footer 3. I have supress blank section checked for GF3 and also I have a formula for Supress(No Drill Down) x+2->isNull ({LOG.AREA}). Yes, I want page header_c to display on both report footer sections. Right now if the there is no data in the subreport it displays page header_b on RFa and page header_c on RFb. If there is data in the subreport then it displays Page Header_c correctly on RFa and RFb.

 

[lbass]

Can you verify that you have new page before set on RF_a? I can't see how this could happen if you have this set.

-LB

 

[maggi]

Yes, I do have new page before set for RF_a.

 

[lbass]

Then maybe check to make sure you are using the correct formula in the conditional suppression for PH_b. Also make sure you have {@true2} placed in the RF_a section. Otherwise, I can't really see why this would happen.

-LB