Execute formula only when group changes 3

[zemp]

CR XI

I have a report in which I have a formula to increment a shared variable in the GH1. GH1 is set to repeat on each page.

I would like my formula to ecexute only when GH1 changes and not every time GH1 prints.

Is there a way to achieve this?

zemp

 

[synapsevampire]

Try:

whileprintingrecords;
numbervar MyNumber;
If previous({table.groupedbyfield}) <> {table.groupedbyfield} then
MyNumber:=MyNumber+1;
MyNumber

-k

 

[lbass]

Or you could use the function: inrepeatedgroupheader, as in:

whileprintingrecords;
numbervar MyNumber;
If not inrepeatedgroupheader then
MyNumber:=MyNumber+1;
MyNumber

-LB

 

[IdoMillet]

Crystal provides a nice special expression for this (InRepeatedGroupHeader). Using this expression, here's an alternative approach:

whileprintingrecords;
shared numbervar MyNumber;
If Not InRepeatedGroupHeader then
MyNumber:=MyNumber+1;
MyNumber

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

Oops, yes, that should be "shared numbervar".

-LB

 

[zemp]

Thanks again, that did the trick.

zemp