Solved

How to format Number in SSRS

Posted on 2009-03-31
3
5,810 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
catherinelouise earned 125 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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Suggested Solutions

Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

730 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