Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSRS Report will not render numeric values Expand / Collapse
Posted Friday, April 12, 2013 10:00 AM


Group: General Forum Members
Last Login: Thursday, May 19, 2016 12:23 PM
Points: 18, Visits: 181
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?

Post #1441778
Posted Tuesday, April 16, 2013 8:48 AM


Group: General Forum Members
Last Login: Friday, December 11, 2015 7:14 AM
Points: 486, Visits: 210
I see you tried "conversion operators CDbl, CInt and Cstr", but this is in SSRS, right?

How about trying Convert or Cast in the SQL, to say a varchar field. Then format as desired using string functions in SSRS.

Post #1442786
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse