Common Expressions Format syntax errror!

Hi All
I have three data sets in a report.
I am trying to format an average based on of the data sets (pManagerAvg),
here is what i have :
= " Average hrs/manager --> Total Finished: " & Avg(Fields!
Measures_Finished_Count.Value), "pManagerAvg")
This works fine, however I get 156.8956235698 as a result. I would like to
show only 156 withput the decimal. I tried Format as follows, as per BOL
without the adtaset specification:
= " Average hrs/manager --> Total Finished: " & Avg(Format(Fields!
Measures_Finished_Count.Value,"#,##)), "pManagerAvg") and i am getting
"The value expression for the textbox ?textbox1? contains an error: Format
specifier was invalid."
Can anyone help here to get the proper Format working.
Thank you in advance.
--
Message posted via http://www.sqlmonster.comThe Format function call has to be applied to the result of the Avg
function.
= " Average hrs/manager --> Total Finished: " &
Format(Avg(Fields!Measures_Finished_Count.Value, "pManagerAvg"), "#,##")
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"James Woo via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in
message news:63c20858525d42e6bd8708d9ca4c589c@.SQLMonster.com...
> Hi All
> I have three data sets in a report.
> I am trying to format an average based on of the data sets (pManagerAvg),
> here is what i have :
> = " Average hrs/manager --> Total Finished: " & Avg(Fields!
> Measures_Finished_Count.Value), "pManagerAvg")
> This works fine, however I get 156.8956235698 as a result. I would like to
> show only 156 withput the decimal. I tried Format as follows, as per BOL
> without the adtaset specification:
> = " Average hrs/manager --> Total Finished: " & Avg(Format(Fields!
> Measures_Finished_Count.Value,"#,##)), "pManagerAvg") and i am getting
> "The value expression for the textbox 'textbox1' contains an error: Format
> specifier was invalid."
> Can anyone help here to get the proper Format working.
> Thank you in advance.
> --
> Message posted via http://www.sqlmonster.com|||Thank you very much. :)
--
Message posted via http://www.sqlmonster.com