formula for the group footer.

[jmeckley]

currently I have the following formula in my report footer

numberVar total;
if({source.year} = {@current_year}) then total := total + {source.january};
total;

this is duplicated for each month.
I also need to include something similar in group#1 footer. i have tried

numberVar total;
if({source.year} = {@current_year}) then total := total + sum({source.january},{source.group_a});
total;

but the results are incorrect. the summation is not correct, and the values are not reset between groups.

I have done this before using running totals and defining an Evaluate formula and Resetting on the change of group_a.

I'm trying to do this by formula so I can create the formulas at runtime, instead of manually defining each formula at design time.

new ReportDocument()
   .DataDefinations
   .FormulaFields["name"]
      .Text = dynamically_create_formula_from(something);

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[dgillz]

The summation formula needs to be in the section where the object you want summed is located, such as the group footer. Then in the report footer you place a display formula:

WhilePrintingRecords;
Numbervar total;

As far as the code goes, you are in the wrong forum, you need to go to the crystal reports integration forum which specifically deals with crystal reports embedded in a VB or .NET project. Probably other languages too.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[jmeckley]

The summation formula needs to be in the section where the object you want summed is located, such as the group footer. Then in the report footer you place a display formula:

right, the formula is in the group footer. this is where I want the value displayed. however the calculation I am using (the formula above) is not producing the expected results. i would assume this is because my formula is wrong.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[jmeckley]

I found a solution.

http://www.crystalkeen.com/articles/crystalreports/runningtotalvar.htm

I'm not totally sold on it, but it works and I can automate (hack) this... somehow

Jason Meckley
Programmer
Specialty Bakers, Inc.