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