<div>
Wow...I got a little ahead of myself...2005
</div>


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

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


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

<div>
<div class="content wysiwyg-content">
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.<br />
No matter how I do a 'custom' format for the expression it never changes.<br />
<br />
Any asssitance is appreciated as this is a report I need ot complete ASAP.<br />
<br />
Thanx
</div>
</div>


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

Format AVG value in Reporting Services

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.