Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 13, 2014 7:51 AM
Points: 9, Visits: 143
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?

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

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 11, 2014 11:00 AM
Points: 335, Visits: 190
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