?
Solved

Format AVG value in Reporting Services

Posted on 2007-08-02
3
Medium Priority
?
328 Views
Last Modified: 2013-11-26
I am using SQL Server 2000 Reporting Services adn on a report I am averaging results of a returned column, using the AVG function in reporting services. My problem is the returned value willnot format properly. I am trying to format a an average wage so shoul dlook like $9.78 but shows like $9.77666666663.
No matter how I do a 'custom' format for the expression it never changes.

Any asssitance is appreciated as this is a report I need ot complete ASAP.

Thanx
0
Comment
Question by:rodn
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
gigglick earned 2000 total points
ID: 19619030
I use this in 20005 but it should work in 2000: Set the properties to...

Value:  = Round( (Fields!MyItem.Value),2)
Format: #,##.00  

You'll need to concat the $
0
 
LVL 5

Expert Comment

by:gigglick
ID: 19619034
Wow...I got a little ahead of myself...2005
0
 

Author Comment

by:rodn
ID: 19619185
Thanks gigglick I had tried the ROUND func but must have for got the parameter. What we forget when frustrated with the more simple solutions :-)
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

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