simple numbering of groups 2

[johnstrang]

Hi,

I have a simple problem which I cannot understand.

Using CR 8.5, I simply want to number the groups in a report - so required output is
1 First Group Name
detail lines

2 Second Group Name
detail lines

3 Third Group Name
detail lines

etc.

In RH I have a formula init_line_nr

numbervar line_nr := 1 ;

In GF1 I have formula inc_line_nr

numbervar line_nr := line_nr + 1 ;

In GH1 I have formula line_nr

numbervar line_nr ;

Problem is that variable line_nr is being reset to 1 for each group. I have tried several options, without any success, including defining the variable line_nr as global.

Why is it doing this? Surely it should increment at the end of every group.

Any information will be gratefully received.

John

 

[mbarron]

It's an evaluation timing issue. Precursor each of your formulas with:
whileprintingrecords;

your RH would look lie this:

whileprintingrecords;
numbervar line_nr := 1

Mike

 

[vidru]

Try using the special field GroupNumber instead of using formulas. If that won't work for you, adjust your formulas like this:
[tt]
//ReportHeader formula
WhilePrintingRecords;
numbervar line_nr := 1 ;

//GroupHeader formula
WhilePrintingRecords;
numbervar line_nr;

//GroupFooter formula
WhilePrintingRecords;
numbervar line_nr := line_nr + 1;
[/tt]
-dave

 

[johnstrang]

Mike,

That's perfect - as soon as I saw your answer I realised that was the problem. I should have known it myself

 

[johnstrang]

Dave,

I didn't know about group_number - that also works perfectly.
Many thanks,
John

 

[mbarron]

One caution on the GroupNumber field. If you have multiple layers of groups, each grouping gets counted.

Using the GroupNumber field:
GH1 GroupCounter = 1
GH2 GroupCounter = 2
GH3 GroupCounter = 3
GH2 GroupCounter = 4


Using your method:
GH1 GroupCounter = 1
GH2
GH3
GH2 GroupCounter = 2




Mike