Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Formatting the number in SSRS Expand / Collapse
Author
Message
Posted Wednesday, April 2, 2014 10:42 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 2, 2014 1:06 PM
Points: 55, Visits: 109
Hello,
How to set the number from 3296317 to 3,296,317

After going to text box properties -> clicking on number how can I set the format for the below number to show up on report

3,296,317

right now I am getting 3296317
Post #1557604
Posted Wednesday, April 2, 2014 12:06 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 12:06 PM
Points: 175, Visits: 6,850
I have seen this done by setting the format to #,###,###
Post #1557640
Posted Wednesday, April 2, 2014 9:01 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:03 PM
Points: 2,967, Visits: 2,569
Use the Format "N0" - you can use this in the format property of the field.


Post #1557789
Posted Friday, April 4, 2014 4:22 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 15, 2014 5:11 AM
Points: 43, Visits: 235
Can't you just check the 'Use 1000 separator (,)'?



  Post Attachments 
sep.jpg (4 views, 140.67 KB)
Post #1558427
Posted Thursday, April 10, 2014 7:05 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:03 PM
Points: 2,967, Visits: 2,569
david.annable (4/4/2014)
Can't you just check the 'Use 1000 separator (,)'?



Yes, you can - this is another way to set the format property. Doing this will set the format property to "N0" (assuming you select 0 decimal places).



Post #1560409
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse