Get the Value of Formula from CR Viewer

Question

 

Hi ,

How to get the value of Formula in my C# application.
Am getting the text of the Formula and not the value.

I have a Formula in Crystal Report.Sum ({AuditReport_csv.Active})

 

I am using the following code to get the value of the formula.

FormulaFieldDefinitions formulaDefenitions = Rpt.DataDefinition.FormulaFields;

FormulaFieldDefinition frDef = formulaDefenitions[0];

string valDef = frDef.Text;

 

The Problem is am getting the Text of the Formula (Sum ({AuditReport_csv.Active})) and not the value.

 

What should i do inorder to get the value and not the text in C#.

Answer 1

Hi,

 

I have the same problem

 

How to get the result of the formula is not the text of the formula?

Please help

Answer 2

Hi

You can get it from here: this.CrystalReport11.Rows[0]["@form01"]. Where CrystalReport11 is of type ReportObject and "@form01" is a name of your formula field.