use a formula in the select expert

[thorny00]

Using CR version 8.0
I have 2 formulas:
balance1 which resides in the group header 2 as
Whileprintingrecords;
NumberVar StartVal:= {CONST_FUNDS_AVAILABLE_WITH_PI.CONSTESCROWAMT}
this is the starting balance

and
balance2 which resides in the detail secions as
whileprintingrecords;
numbervar StartVal;
StartVal:= StartVal-{CONST_FUNDS_AVAILABLE_WITH_PI.DRAW_AMOUNT}
this is a running balance

what I want to do is in the select expert say:
balance2 > 0
problem is balance2 doesn't show when I pull up the select expert. Any ideas as to why it doesn't show???

All help and time is greatly appreciated !!

 

[lyanch]

Since balance two is not even calculated until the records are being printed how could it be known before the data is even selected?

Lisa

 

[Wallie12]

Try preforming this calculation in your SQL, prior to entering report.

 

[lbass]

Instead of using a running bal, perhaps you could change your second formula {@balance2} to the following and place it in the group header:

whileprintingrecords;
numbervar StartVal;

StartVal + sum({CONST_FUNDS_AVAILABLE_WITH_PI.DRAW_AMOUNT},{table.groupfield})

Then you could go to the section expert->group header, details, group footer (repeat for each)->suppress->x+2 and enter:

{@balance2} <= 0

-LB