I am having the exact same issue. There was no change in disk consumption on either server (prod and backup). Additionally, the log files show that the data...

Which version of SSRS are you using? Are you doing your testing in Business Intelligence Development Studio?

Can you post code for the stored procedure you are calling to populate your State dropdown box?

jpwagoner...that must be a new feature in SSRS 2008. I don't see it in 2005.

As far as I'm aware a cursor is the only way to do this.

--Create #temp table and insert numbers

DECLARE int_cursor CURSOR

FOR SELECT intVal FROM #temp

OPEN int_cursor

DECLARE @currInt...