Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  Exporting Matrix to Excel

Author  Topic  Cj2883 Starting Member 1 Post Posted - 2005-12-27 : 10:55:53 I have a matrix report in RS. The majority of the report's data is in currency format. When I export this report to Excel, the tool changes the data type to string, but leaves the dollar sign on there. This locks the format into string and will not allow me to perform any calculations on the numbers. Is there a way that I can fix this on the server's side?