Format AVG value in Reporting Services

Posted on 2007-08-02
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.

Question by:rodn
    LVL 5

    Accepted Solution

    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 $
    LVL 5

    Expert Comment

    Wow...I got a little ahead of myself...2005

    Author Comment

    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 :-)

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now