开发者

Formatting the number in SSRS

I want to format a numeric value to two decimal points (it is an integer variable) I am using following expression (as used to use in vb6) but it is not working. Please adv开发者_如何学编程ise how to fix it.

="Total Drawings Rs. " & format(Parameters!TotalDrawings.Value,"@@@@@@@@@@@.00")"

Thanks Furqan


You use .net format string, not VB6/VBA

= "Total Drawings Rs. " + Format(CDbl(Parameters!TotalDrawings.Value), "##########0.00")

Edit: fixed concat + trailing " + CDbl

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜