Thanks everyone and thanks:-) for the link.

I had goggled it prior and I read a blog that hinted that I needed a function.

Thanks, I tried that and it did switch...

I added a Null Value to the table that is used to populate the list-box, I select Null but I get no results.

The Stored Procedure has the following criteria:

AND...

Thanks!

I have specified to allow NULL in the parameters dialogue box.:unsure:

Thanks. The problem that I'm dealing with is that my Stored Procedure allows nulls but I must Select a State or I get an error.:hehe:

I spoke to soon, modified the SP to Accept a NULL value and the report defaults to the last State that I selected in the Drop Down Box.

Thanks everyone, I deleted the parameters and Dataset, recreated and all of my problems went away.:crazy:

SSRS 2005 & I'm testing in BIDS.

I deleted the parameter but the data is still filtered by State?:laugh:

Caching?

I have made some progress.

I created another Data Set to poulate the list...

So far I have created a Stored Procedure with a State Parameter.

I changed the Data Source to the Stored Procedure.

I have a Drop Down Box and it displays the States...

Disregard the last post.

I figured it out.

Thanks for the instructions.

Sorry but I do not follow you.

I have a row with the Column Names.

Then I have a group with the State.

On the Detail row I have the Company Name, City,...

Gianluca Sartori (1/10/2012)

---

You're trying to make your PIVOT dynamic, right?

Then just use dynamic SQL. In your example, the variable that determines the number and content of columns is the year:...