How do I modify default [value] formatting

Posted on 2011-03-03
Medium Priority
Last Modified: 2012-05-11
Need assistance - please view attached image for view of the problem. Have my report all ready to go. Used the Report Wizard to generate the .rdl.
When I generate the report, I am able to modify formatting on any of the totals on the expanded information, but I cannot figure out how to modify the format of the system-generated SUM on the payment amount.  This was entered in the VALUE box using the wizard. It's coming up as ######.####  and I want to only see two decimal places, not four. The reformatting works on the fields when you expand the results to see the details, but at the summary level, it's stuck at four decimals.  THE UNDERLYING DATA CARRIES FOUR DECIMAL POINTS.
  Report Builder Formatting Report Builder Formatting
Question by:gberkeley
LVL 40

Accepted Solution

lcohan earned 1000 total points
ID: 35030668
Edit your report in Visual Studio/Busines Inteligence, click the "Total" field and under properties there is "Format" under "Number" section - or you could use "Localization" locale ID which will be tied to the Windows locale settings.

Author Closing Comment

ID: 35030684

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…
To export Lotus Notes to Outlook PST or Exchange and Domino Server files to Exchange Server or PST files with ease, go for Kernel for Lotus Notes to Outlook conversion tool. Through the video, you can watch the conversion process. A common user with…

627 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