Deployment Issue

We have a requirement to display some 80,000 records in the report. The Stored procedure in the back end is displaying results in less than 2 mins..but the system hangs when we run the report.

Any work around for this strange behaviour?

When you run a report, not only do you have to collect the data, you also have to render the report, 80K records is 800 pages if you have 100 records per page.

What happens if you run the report as a scheduled report, and set the run time to the middle of the night when database and report server activity is low?

Dependant Dropdown Filters displaying <Select a Value>

I have a few reports that we have filters where our client can select from dropdown menus. There are four menus and each one is dependant on the previous one. The problem is that initially all of the dropdowns are defaulted to <All>, but once you have gone and selected a value in the dropdowns then you go back and change any of the dropdowns, the dropdowns that are then dependant on the dropdown changed revert to <Select a Value> instead of going back to the default assigned of <All>. This is happening to all of the dropdowns dependant on the one changed no matter how many are changed initially or left alone.

Is there any way to revert them back to their assigned default <All> or is this a bug in SQL Server Reporting Services?

Is there anyone who can help me out with this issue?

Thank you for any help you may have.

Dependant Dropdown Filters displaying <Select a Value>

I have a few reports that we have filters where our client can select from dropdown menus. There are four menus and each one is dependant on the previous one. The problem is that initially all of the dropdowns are defaulted to <All>, but once you have gone and selected a value in the dropdowns then you go back and change any of the dropdowns, the dropdowns that are then dependant on the dropdown changed revert to <Select a Value> instead of going back to the default assigned of <All>. This is happening to all of the dropdowns dependant on the one changed no matter how many are changed initially or left alone.

Is there any way to revert them back to their assigned default <All> or is this a bug in SQL Server Reporting Services?

Is there anyone who can help me out with this issue?

Thank you for any help you may have.