开发者

Formatting the number in SSRS

开发者 https://www.devze.com 2023-03-13 15:07 出处:网络
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 f

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

精彩评论

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