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

need group header on each page

Status
Not open for further replies.

atarrqis

IS-IT--Management
Nov 26, 2004
155
US
I have a report - Analysis Results - that has 3 groups
Report header
Page header = Data_Point Norm_Type Test_Op_No
gh1 - TEST_OP_NO xxxx xxxxxxx xxxxxxx (these are all Attributes)
gh2- DATA_POINT (suppressed)
gh3- RESULT_NO = Result_No Outer_Max Outer_Min
detail xxxx xxxx xxxx (these are NOT Attributes)
xxxx xxxx xxxxx


In gh3 (header) I have a formula, grpcnt:
WhilePrintingRecords;
NumberVar GrpCnt;
IF {ANALYSIS_RESULTS.CONTROL_CHART_TYPE_DB} = 'ATTRIBUTE' then GrpCnt :=1
ELSE
if IsNull({ANALYSIS_RESULTS.RESULT_NO}) OR {ANALYSIS_RESULTS.RESULT_NO} = previous({ANALYSIS_RESULTS.RESULT_NO})
then GrpCnt :=1
else
if {ANALYSIS_RESULTS.RESULT_NO} <> previous ({ANALYSIS_RESULTS.RESULT_NO}) then grpcnt := 1 + grpcnt
;


In gf3 (footer) I have a formula, pagereset
WhilePrintingRecords;
NumberVar GrpCnt;
if {ANALYSIS_RESULTS.CONTROL_CHART_TYPE_DB} = 'ATTRIBUTE'
then GrpCnt := 1
else GrpCnt := 0;

In the Section Expert for gh3 header, I have Suppress if {ANALYSIS_RESULTS.CONTROL_CHART_TYPE_DB} = 'ATTRIBUTE'
or {@grpcnt}>0

This all works fine – if I remove the Section Expert code, I would get the gh3 header text for every value.
My problem is if I can have alot of lines that extend onto another page and the user would like the gh3 text to print on the new page.
group 3 has ‘Repeat Group Header On Each Page’ but this doesn’t appear to work.
I have no way of knowing how many records will be in this section or where they may appear relative to the records in group 1.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top