Tuesday, February 14, 2012

Can I read the VALUE of a formula FROM a report in VB.NET?

My report does a lot of complex calculations and at the end there is a 'Total' formula.

I want to be able to read that value FROM the report in VB.NET after the report has been printed and use it for another function.

Is this possible?

The closest I've got is this:

rpt.DataDefinition.FormulaFields("Total").Text

but this gives me the text from the formula and not its calculated value...

Any ideas?

Thanks in advanceIt is not possible
You need to do the same calculation in VB.NET
If your Database is SQL Server then create function or stored procedure and put that code as part of it and retrieve the value

No comments:

Post a Comment