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

Trying to get formula data from GH3 to GF1 sections

Status
Not open for further replies.

glthornton

Programmer
Oct 19, 2005
108
US
Hi, I'm working with CR XI against and SQL Server. I'm having trouble trying to get a value from a formula in the Group Header 3 down to the Group Footer 1 so that I can us it for finishing out some calculations.

Code:
To look at the my report and what I'm asking, go to below link:
[URL unfurl="true"]http://www.driveway.com/jkidx86620[/URL]

I am clearing my Group Header variables in the Group Header 1 area. So I know these calculations are working just fine. For further explaination, I need to get the value in the GH3 section called {@Tot TCD} to the GF1 section so that I can take the Total # of Committed Vistis and divide that into the value in {@Tot TCD} giving me the Average days per commited visits to complete value. And the same for the other side of the report. I'm just going brain dead on how to get these values down to the GF1 section. Any assistance would greatly be appreciated. Kind regards, Glenn
 
Can't get there from here. If you are using variables, then you need to set the amount up as a variable that is not reset before GF1. For more help, please identify your groups and show the content of your formulas and say in what report section they are located.

-LB
 
A summary total is created at a particular level. If you need it at more than one level, you have to create a new total applying the same rules at that level.

The use of Crystal totals is outlined at FAQ767-6524.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top