?
Solved

How to format Number in SSRS

Posted on 2009-03-31
3
Medium Priority
?
5,853 Views
Last Modified: 2012-05-06
I had number in the following format in SSRS -> 898945.45
I need to change to the following Format -> 898,945

How can i Do it. I dont want to have any decimals or currency symbols.
0
Comment
Question by:bsumanrao
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
catherinelouise earned 500 total points
ID: 24032742
In the Format field of the Properties tab, enter N0.

You can also get to this by right clicking on the relevant cell, choose Properties, select the Format tab, and entering N0 in the Format Code box.
0
 

Author Comment

by:bsumanrao
ID: 24032790

Besides ", " i want to have it as "." What should i do
0
 
LVL 5

Expert Comment

by:catherinelouise
ID: 24032889
I believe this is defined according to the Digital Grouping Symbol specified in your regional settings.
http://msdn.microsoft.com/en-us/library/system.globalization.numberformatinfo.numbergroupseparator(VS.71).aspx
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
Screencast - Getting to Know the Pipeline
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses
Course of the Month14 days, 11 hours left to enroll

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question