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  General SQL Server Forums  New to SQL Server Programming  RS 2008 - Newbie question on types and formats

Author  Topic  LTG Starting Member 1 Post Posted - 2009-06-15 : 12:33:42 Hi, I am trying to get decimal types in a RS 2008 report to NOT be converted to text when the report is saved in Excel format. This is what I've tried so far: No formatting: Fields!Amount.Value Incorrect - Excel export works, but report displays 4 trailing zeros when not exported and in PDF. Currency formatting: Format(Fields!Amount.Value,"c0") Incorrect - Report displays perfectly when not exported and in PDF, but Excel cell types are NOT numeric. Number formatting: Format(Fields!Amount.Value,"#.#") Incorrect - Report displays perfectly when not exported and in PDF, but Excel cell types are NOT numeric, they are TEXT. Any ideas appreciated, Lee