Wednesday, March 21, 2012

Matrix Report Exporting

I have a Matrix report in RS and I am trying to export it to Excel. The data in the report is formatted as currency. The data does transfer fine, but the currency values are stored as strings. This will not allow me to perform calculations. I have not had this problem with table reports, only the matrix. Is there any solution that be performed on the server side?

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