Click here to Skip to main content
12,398,181 members (45,308 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SSRS
Hi,
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 advise how to fix it.
="Total Drawings Rs. " & format(Parameters!TotalDrawings.Value,"@@@@@@@@@@@.00")"
Thanks
Furqan
Posted 16-Jun-11 0:58am
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Use
=Format(CDbl(Parameters!New.Value), "###,#######0.00")

This is the only thing that works ............
  Permalink  
Comments
thatraja 19-Jun-11 3:27am
   
Did you check the 2nd link in my answer? It has many formats.
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Here you go

Expression Examples (Report Builder 3.0 and SSRS)[^]

EDIT
---------------------------------
Format to 2 decimal places[^]
  Permalink  
v2
Comments
kfsehgal 18-Jun-11 2:14am
   
Thank you but I could not find solution to my problem. Did I overlook something?
Thanks
Furqan
thatraja 18-Jun-11 7:05am
   
oops, my bad. check my updated answer.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 19 Jun 2011
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100