URGENT: Cascading Parameters in SQL Server Reporting Services 2005

  • I have a Reporting Services 2005 report which uses cascading parameter multi-select drop-down boxes. The report runs perfect after making initial selections. However, each subsequent parameter selection causes the page to refresh to a blank page until the View Report button is clicked. What I would like to happen (which should be the norm) is for the user to be able to make all necessary selections without the page auto-refreshing after each selection. The user would then click the View Report button to regenerate the report. We are currently using reports which contain up to 5 cascading parameters. This becomes very time-consuming when the page refreshes after each selection.

    Has anyone come across a solution or code alternative to this problem??

    Any help would be most appreciated.

    Thank you.

  • This is the "norm" if the parameters have dependencies.

    I too have this but users dont seem to complain too much (allows then to work slower ;-))

    http://jetlounge.net/blogs/teched/archive/2007/12/13/strange-refresh-of-parameters-in-sql-reporting-services.aspx

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply