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
精彩评论