Suppress field in page header 1

[ekta22]

Hi,

I have 6 grouping in my report as follows

Region
Sector
SubSector
Interval
Area
Crewunit

I have a crosstab in Interval group header that displays all the areas found in that interval as column heading and crewunit as row headings. My page header has the area field. What it is doing right now is that it displays the first area it finds for that interval on the page header. I don't want it to display the area field on the page header where it displays the cross tab. Here is some sample data.

Page Header
Region - Eastern
Sector - 11
SubSector - C
Interval - Weekly or Greater
Area - Area1

Interval Group Header

Area1 Area2 Area3 Total
crew1 10 10 10 30
crew2 5 3 5 13
Total 15 13 15


If you see that it displays Area1 on the page header where it displays the crosstab. I want to display the area on the next page where it lists the records in detail for each area. How should I supress this field?

Thanks

 

[lbass]

Assuming that the crosstab is on its own page, you can create two formulas:

//{@false} to be placed in the report header AND in group header #5 (area):
whileprintingrecords;
booleanvar flag := false;

//{@true} to be placed in the group header #4 (interval):
whileprintingrecords;
booleanvar flag := true;

Then right click on your area field in the page header->format field->common->suppress->x+2 and enter:

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

-LB

 

[ekta22]

Thanks, that worked great.