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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I read the VALUE of a formula FROM a report?

Status
Not open for further replies.
ElaineRC

ElaineRC

Programmer
Jan 20, 2005
7
GB
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 advance
 
Status
Not open for further replies.

Similar threads

tlbrown88
  • Question
How does one get the results of a Calculation (SharedVar) on the same line as the Sub Report?
Replies
3
Views
184
lbass
lbass
D
  • Locked
  • Question
Running total from a subreport only showing last value
Replies
4
Views
662
doodledump
D
Corinne30
  • Locked
  • Question
Division of currency formula with/without rounding
Replies
7
Views
856
dgillz
dgillz
B
  • Locked
  • Question
Difference of a field between 2 variable dates
Replies
1
Views
266
hilfy
hilfy
T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
567
TPG_IT
T

Part and Inventory Search

Sponsor

Back
Top