Formula calculation on group footer

[slim2]

Thanks to all who have responded to help me on the shared variable problem on my report. One more question.

Can anyone tell me where I can find information, as yet I have not been able to, about when a formula is evaluated and what/where these events are available at. I want to process a shared variable prior to other formulas at group break. That is, I have an array of 13 accumulated fields and will just print them in the footer but want to perform a calculation on them before the actual print formula??

Thanks again

 

[Ngolem]

if using a subreport to pass shared variables back for calculation,
- create a subsection above the section which uses the shared variables...put your subreport in there,
- make all sections of the subreport suppressed so they don't show in the mainreport,
- don't suppress or conditionally suppress the main report subsection or the subreport won't work.
- make the subreport as thin as possible (I color code all subreports backgrounds conditionally RED so I can find them later eg. if 1 = 1 then crNoColor else crRed)

As far as formula's go I always put "WhilePrintingRecords" in all formuals except those used for summarries or grouping and use occassionally "EvaluateAfter(Formula)" if that is important.

hope this helps

Jim

 

[slim2]

I am not using subreports. It is all in Main and just printing totals and calculations in the footer. Is there
EvaluateFirst, is there anywhere I can find a list of Evaluate.... While..... events

So I have 13 formulas printing and I want to do a calculation before printing them something like EvaluateFirst in the footer

Thanks

 

[Ngolem]

You mentioned Shared variables and that is the only time you use them is to transfer info from a subreport to mainreport???

look under Functions|Evaluation Time in the formula editor

 

[slim2]

Jim,

Sorry for the mistake, they are defined as Global, i keep calling them shared because I use them accross formulas.