Thank y'all

No Worries, Tweaking the query made the difference

Thank you

Well, This did the trick...IIF(Parameters!TEAM.Count =Count(Fields!TEAM.Value, "Parameter"),"All Group",Join(Parameters!TEAM.Value, ", "))

I see. Thank you

Can I use a temp table instead of @DelimitedSplit8K?

Wondering why are we using dbo.DelimitedSplit8K?

Oh Yes. Why didn't i see that ..

Thanks a ton

I am following this thread , but it isn't very clear.

Can someone give step by step detail for 2012.

All I am trying to do is get a format which is like CURdate in SQL.

True, I cannot change the table .

Name is the name of the person , Project is the projectname and all the weeks represent the hours worked on the project.

Yes , its for reporting

Thanks. Will try that

I should have added this too:

Insert INTO #mytable

(Month_Year ,MyMonth,MyYear,ACC_Opened ,ACC_Opened ,ACC_Closed ,ACC_Backlog ,TimeStamp )

Select 'Apr-2014', '4', '2014','Investments','128','133','12', '2014-06-11 09:57:55.477'

UNion All

Select 'Aug-2013', '8', '2013','Investments','118','143','10', '2014-06-11 09:57:55.477'

UNion All

Select 'May-2014', '5',...

Here it is :

CREATE TABLE #mytable

(

Month_Year Varchar(10),

...