Another option that will allow you to keep your current update statement unchanged is to declare a variable for 'YYYYMM'.

DECLARE @YYYYMM varchar (6)

--This is where you set the variable equal...

To display the multivalue parameters, use the following syntax in a textbox. =Join(Parameters!Test.Value, ", ")

If you need to display the contents of the multivalue paramater in a table, create...

Not the most elegent code, but this has been working for me. In my case, there can only be 1 line below the first line. It would need...

6 months a year another developer and I hacky sack one or two times a day, the other 6 months are too cold to be outside so I push through...

With SSRS 2005, I have a matrix report that shows months going down the left side (y axis) and years across the top (x axis). If you click on...

Day in and day out is currently spent with SSRS, so I am going to learn SSIS. I used DTS quite a few years back so I think that...

KB – 2000, The only way I have found to have a “Dynamic” pivot list is to use a single variable in place of [A],,[C],[D],[F],[G],[T] and then use Exec(@SQL) to...

Could you use the PIVOT operator? Once I ran your SQL to create the table, I used the code below to achieve the expected results.

Select COL1,

CASE WHEN [A]...

Could you create an "Employee" drop down parameter? Then if an employee runs the report, the only value would be their name, otherwise if a supervisor logged in, then...