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

Reset formula 1

Status
Not open for further replies.

CoSpringsGuy

IS-IT--Management
Aug 9, 2007
955
US
Not to ask for someones help by name ;) but LBass!!!

I am having difficulty with a reset formula you have posted in the past.

I have a report with 2 group levels.
in group 1 footer .. I need to count how many times A is greater than B in Group Footer 1

A is a summary field and B is a static value

my attempt......

//countfeelgoal
whileprintingrecords;
numbervar hit;
if Sum ({@TotalFees}, {@datefield}, "monthly") > {@Goal} then hit := hit +1;
hit

//countfeegoalreset
whileprintingrecords;
global numbervar hit := 0;
hit

if I place @countfeelgoal in GF2 and @countfeegoalreset in GH1 it results in a good "runningtotal" in GF2. But I need that count in GF1. When I place it there the value is 1.

What am I missing?

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 
Correction

I have a report with 2 group levels.
in group 1 footer .. I need to count how many times A is greater than B in Group Footer 2

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 
You need a display formula for GF1 (do NOT put the accumulation formula there):

whileprintingrecords;
numbervar hit;

-LB
 
Perfect as always... Thank LBass

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top