Hi there.I have an application that serves up reports for users. They can also schedule the report to be delivered to them in Excel Format. There is some financial data in the report that shows in formatted as currency. When it gets exported to excel, the formatting stays in the data and excel reads the data as text and not numbers.Is there a way to force Reporting Services to render the report without the formatting? Or should I just create two separate reports..One with the formatting and one without?As always, I greatly appreciate any help!ThanksGregOh...Here is the code I am using...If this helps at all..byte[] content = reportViewer.LocalReport.Render("Excel", null, out mimeType, out encoding, out fileNameExtension, out streams, out warnings);
Change Local Report Definition in Code
Posted - 2008-12-03 : 18:55:48