Thanks

it is working wonders

Sorry I was looking at the wrong report

but I'm still getting an error saying : input string was not in a correct format

Hi I tried your suggestion but I still get an error

the value expression for the textbox 'staffcount' has a scope parameter that is not valid for an aggregate function.

Great. Thanks will do

Hi Thanks for the feedback

according to my thinking if headcount = 0 then that department should not even be there. anyway I found that headcount is not 0 but...

Beautiful, Thanks a lot to both of you

It runs but does not count anything

Hi

They are included in the select, but now I get an error that say invalid column names when I use brackets

Yep!

I'm also confused. Iam trying to rewrite a report that was written in excel and the formulas used are just not adding up. To calculate turnover percentage they have avgTerm...

Well....

Period is a numeric field and headcount is varchar.

Period Staffno Headcount

200901 123456 Headcount

200901 345612 ...

Hi

I use the expression you provided

=IIF( Join(Parameters!Consolidate.Value,", ") = "ALL", "Retail HeadCount : "& Parameters!EndPeriod.Value.ToString ,

strConv(Join(Parameters!Consolidate.Value,", "),3) & " HeadCount : "& Parameters!EndPeriod.Value.ToString)

and the consolidate parameter is as...

Hi Gavin

I just don't know what I changed or didn't but it's now working fine. Thank you very much for your help

Hi Gavin

Thanks for the feedback, it works but I would like to replace the word "ALL" with "Retail" during run time.

ie. the heading should be "retail headcount report for period...

Hi Randy

Thanks for the feedback.

I would like to have those totals next tothe related fields. e.g

Totalheadcount should be next to contractors then we'll have vacancies followed by TotalVacancies and...

Thanks for the feedback guys. I think I will use Steve's Idea

- or wrap your own outer layer of control (e.g. aspx app, you handle the collection of parm values...