show decimals
Hi i have values like 0.123242575676563423,0.1,0,1.340534095803,0.343434,0.454564,2.34534534546546 in my output for a SQL statement. But they show blank in ssrs 2008. Is there a way to make them show. Thanks in advance. svk
March 16th, 2011 8:53pm

Hi varunsvk, I think you need to convert the values, something like this:- = CDec ( Fields!Number.Value ) --Assuming "Number" is your column Play around with it, I might not be 100% correct but this is doable. Please let us know your feedback. Thanks KumarKG, MCTS
Free Windows Admin Tool Kit Click here and download it now
March 16th, 2011 9:08pm

Thanks for the reply. But i got #Error. When i used this "=CDec(Fields!RATE.Value)" in the expression of the column.svk
March 16th, 2011 9:14pm

try this, = CDbl ( Fields!Rate.Value ) Thanks KumarKG, MCTS
Free Windows Admin Tool Kit Click here and download it now
March 16th, 2011 9:24pm

That didn't work either. I got the same #Error.svk
March 16th, 2011 9:37pm

Hi svk, It is unusual that the values you posted cannot be displayed in report. Based on the discussion above, I also noticed it shows #Error when use the convert functions. This might be cuased by the format of the values. So could you please the original data type of the RATE field in data source? Thanks, Tony Chain Tony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
March 22nd, 2011 8:29pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics