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.