Manual Running Total Formula Does Not Appear in Alerts!

[jpstrzoch]

Greetings,

I created four formulas in hopes of being able to use them in an Alert!. I placed the formulas in the sections of the report as shown below. Why am I not able to see the formulas when attempting to construct an Alert?

GROUP HEADER 3

@Formula Reset
WhilePrintingRecords;
Global NumberVar := clientunits = 0;

DETAILS

@GF1a - Total Lines
if {ORDRDET.LINENUMBER} > 1
then 1
else 0

DETAILS

@GF1A - Manual Running Total
WhilePrintingRecords;
Global NumberVar clientlines := clientlines + {@GF1a - Total Lines};

REPORT FOOTER 3

@GF1A - Grand Total
WhilePrintingRecords;
Global NumberVar clientlines;

 

[Charliy]

Put the reset formula in Group Footer 3B instead of group header 3. Put it in the Report header as well.
and that one line need to be changed to: Global NumberVar clientunits := 0;

 

[jpstrzoch]

Good evening Charliy!

Thank you for the post! Very much appreciated. I added Group Footer 3B and moved the reset formula to that section. My formula was correct in the RPT.....I just did a typo when posting within the original thread.

Unfortunately I still cannot see the formulas as an election when trying to create a condition for an Alert!.

Any other recommendations would be very much appreciated!

 

[Charliy]

I haven't really worked with Alerts, so this is just a suggestion.

Define the variable in the Alert like:

global numbervar clientlines;
<code for alert>

 

[jpstrzoch]

Good morning Charliy,

Thank you for all your efforts! I greatly appreciate your time! I was unable to make the Alert work but no need for concern I solved it another way.

Thanks again!