I have a SSRS 2005 report that will not render certain numeric values. Nothing special about them, they are definied in the table as decimal(22,7).
I run the stored proc stand alone and the fields have values in them. I preview the report in BIDS and the values display. But when I deploy to the reporting server they all display as 0.000000.
Things I have tried:
Verified the data source is pointed to the correct server and database.
Cleared cache from IE8
Tried in FireFox
Verified Cache properties of report were set to Always run this report with the most recent data
Deleted the report from the server and redeployed.
Dropped the stored procedure and re-created it.
Deleted the table and the dataset from the report and re-created them.
Changed the stored proc to insert into a temp table first and queried the temp table
Changed the formatting to no format, currency, number and custom with varying decimal positions.
Tried conversion operators CDbl, CInt and Cstr to see affect.
Ran report as a subscription to see if any changes.
I am out of ideas. Anyone else ever seen something like this?