It shouldn't matter if the textbox is part of a matrix or a table. What matters is the definition of your text box: the expression you use to calculate its value, the data base field type you bound the textbox to.
Thank you,
Nico
|||The data type in the database is SQL money, and the field type in SQL RS is currency, but it exports into Excel, not as string as I originally thought, but as a custom data type that will not easily convert into a numeric data type.|||Try this: in the matrix cell textbox, instead of just using the field value (=Sum(Fields!A.Value)), convert it into a double: =Sum(CDbl(Fields!A.Value)).
-- Robert
No comments:
Post a Comment