PH not being applied for large Cross Tab 1

[dunlop1975]

I have a report that has a crosstab in RH1 that is a summary of all facilities.

Then in GH1 is a crosstab that is specific to each Facility.

My problem is that the crosstab in the report header can sometimes take more than one page, when it does so it will not apply the hage header until page 3. I understand it is doing this because technically we are still on the RH but I am so far unable to "trick" it to apply the page header.

any ideas?

 

[lbass]

Create a formula that is true for all records, like this:

whilereadingrecords;
""

Insert a group on this and make it your group #1. Move the crosstab from the report header to this new group header.

-LB

 

[dunlop1975]

Worked like a charm, thank you!

 

[dunlop1975]

I ran into a new problem related to this. It solved the intial RH issue.

I had included the in the PH a title (a formula that outputs a string that contains facility name plus locations that were selected in a parameter) to clearly label even when the crosstab spanned more than a page.

Because of the "fake" RH (GH1), this title that is displayed in the PH is not valid for the summary cross tab.

If I change the title to display in the GH, it does not repeat if the crosstab takes more than a page.

As this report has not been released yet, I figured the easy answer was to just put the title formula as either a row or column in my crosstab, but when I do it truncates the string even though there is plenty of space in the cell...arg!

 

[lbass]

I think you can handle this by having two different Page Header sections and then conditionally suppress them. You can set up formulas like the following:

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

//{@true} to be placed in an inserted suppressed GH2a section (with the group crosstab in GH2b):
whileprintingrecords;
booleanvar flag := true;

Then for PH_a, use a conditional suppression formula of:

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

For PH_b, use a conditional suppression formula of:
whileprintingrecords;
booleanvar flag;
flag = false; //note no colon

Be sure to format GH_a to new page after.

-LB

 

[dunlop1975]

Wow, that's fantastic. Worked perfectly, thanks again.