Need to display some Group Footer Results in Page Header

[Montana751]

Crystal XI. I'm in my subreport that is grouped on a formula @GroupFormula(If Account.PoolSide = 3000 then 1, else if 3001, then 2, etc. 4 total) I need to display in the Page Header section (using the details & group footer sections, just to get the Summed Values for groups 1 & 2) the summed value for @GroupFormula = 1 and @GroupFormula = 2. (I then have to display the Group Footer Totals for Groups 3 & 4)

How can I do this using variables? Don't want to use a cross tab.

Example of what I need to display (1 row):
Page Header: Total Group 1 $500 Total Group 2 $2500

GroupFooter: Total Group 3 $1289
GroupFooter: Total Group 4 $1288

Any suggestions?

 

[Montana751]

I got the summary values to display in the page Headerit using 3 Cross-Tabs; one for each total I needed.

Still interested in finding out how to use variables to do it though.

 

[lbass]

If the sub only contains the one group (with four instances), you should be able to create conditional formulas like this:

//{@grp1amt}:
if {@group} = 1 then {table.amt}

Then you could reference this in the subreport report header (there are no page headers), by using a formula like this:

sum({@grp1amt})

-LB