im using reporting services 2005 and want to format my days field which is in an interger format currently the values look like this below... 40.3277776 1817.8743004 1372.8800485 849.2818850 134.9999995 i want the results to like 40.32 1818.87 1372.88 849.28 134.99

Hi, You need to follow following steps in your reporting service report 1) right click the text box for which you want to change the format 2) Click Text Box Properties 3) In Text Box Properties dialoug box Click Number From the Left. 4) Select Number From Category set the Decimal places properties to 2. 5) Click OK 6) Preview the report. Also, follow the below link for some useful functions of reporting service. http://msdn.microsoft.com/en-us/library/ms157328.aspx Failure in Life is failure to try... PGDCA-98(South Gujarat University),MCTS (SQL Server 2005)

Hi, You can use the next expression: FormatNumber(Fields!YourFields.Value, 2). Regards!Fran Daz | {geeks.ms/blogs/fdiaz/} | {onobanet.com} | {secondnug.com}

Sum(Fields!myFields.Value) does it work for sum too? can't get it to work?

Hi, You need to follow following steps in your reporting service report 1) right click the text box for which you want to change the format 2) Click Text Box Properties 3) In Text Box Properties dialoug box Click Number From the Left. 4) Select Number From Category set the Decimal places properties to 2. 5) Click OK 6) Preview the report. Also, follow the below link for some useful functions of reporting service. http://msdn.microsoft.com/en-us/library/ms157328.aspx Failure in Life is failure to try... PGDCA-98(South Gujarat University),MCTS (SQL Server 2005) this will not for a matrix table... below is the current expression =iif(sum(Fields!bdays.Value) = 0, "-", sum(Fields!d_used.Value)/sum(Fields!bdays.Value))