Click to See Complete Forum and Search --> : Supress field in page header


gems
October 7th, 2005, 10:28 AM
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

RobDog888
October 7th, 2005, 08:34 PM
Report > Change Group Expert > Change Group > Options... button > Group Options > check "Repeat Group Header On Each Page" > click Ok.

Err, if you want to supress the display of it, it should be unchecked.