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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unique Page Numbering in Group Header Only Report

Status
Not open for further replies.

MGCHRIS

IS-IT--Management
Dec 12, 2011
1
US
I have a unique query. I have a report that is created with Group headers only. (inherited not own creation). I don't want to have to redo the whole thing as it is 36 pages (Property lease agreement). I would like to be able to have page numbers for the "lease section" and nothing for the remaining sections. Is this even possible?

Setup:
Report header (suppressed)
Page header (suppressed)
Group header #1(a-af)
Details(suppressed)
Group Footer(suppressed)
Report footer (suppressed)
Page Footer (NOT suppressed) - This is where I have page numbering and a few other disclaimers.

Again would it be possible to have page numbering for Group header #1c - #1f and nothing for the other GH's?

EX:
GH#1a & #1b no page numbering or ii, iii, etc
GH#1c - #1f page numbered as 1 of 4, 2 of 4, etc
Remaining headers no numbering

Thanks in advance. I am assuming I am going to eventually have to redo this whole thing to achieve a lot of the things. But would prefer not to as there are 36 variations of this rpt with the same numbering request.
 
First make sure you have formatted each GH1 section to New page after and to reset page number after. On the last section add a formula to the new page after x+2 area:

not onlastrecord

Then create the following formulas in the field explorer and place them as noted:

//{@false} to be placed in GH1c:
whileprintingrecords;
booleanvar flag := false;
booleanvar flag2 := false;

//{@true} to be placed in GH1a:
whileprintingrecords;
booleanvar flag := true;

//{@true2} to be placed in GH1g:
whileprintingrecords;
booleanvar flag2 := true;

Add page N of M to the page footer and then right click on it->format text->suppress->x+2 and enter:

whileprintingrecords;
booleanvar flag;
booleanvar flag2;
flag = true or
flag2 = true; //note no colons

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top