Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formatting Page Headers/Group Headers.

Status
Not open for further replies.

punty

Programmer
Nov 6, 2003
2
IN
Hi,
We have a report, which has column headers in page header and as well as in group header. The report has only one grouping. On one of the pages in the report the group header appears right below the page header. In this case there is repetition of column headers. Is there a way to eliminate this?
 
Well, one approach might be to not use the page header at all (or at least not the portion of it that has the column headings), and for the group header set the option to Repeat Group Header On Each Page. This way, the group header would always show the column headings.
 
The requirment is such that we need column headers in both page header as well as group header. My problem is repetition of column headers.
 
I think you could use two formulas as follows:

{@resetlinecnt} to be placed in the page header:
whileprintingrecords;
numbervar linecnt := 0;

{@linecnt} to be placed in the group header and in the details section:
whileprintingrecords;
numbervar linecnt := linecnt + 1;

Then go to format section->group header->suppress->x+2 and enter:

{@linecnt} = 1

This should suppress the group header whenever it is the first line on the page.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top