Click here to Skip to main content
Rate this: bad
good
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 1: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 at 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 at 18-Jun-11 2:14am
   
Thank you but I could not find solution to my problem. Did I overlook something?
Thanks
Furqan
thatraja at 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
0 Sergey Alexandrovich Kryukov 8,478
1 OriginalGriff 6,516
2 Peter Leow 3,567
3 Zoltán Zörgő 3,386
4 Richard MacCutchan 2,397


Advertise | Privacy | Mobile
Web01 | 2.8.150123.1 | Last Updated 19 Jun 2011
Copyright © CodeProject, 1999-2015
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