URGENT: Cascading Parameters in SQL Server Reporting Services 2005

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • broadiea
    New Member
    • May 2007
    • 1

    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.

    Tony
Working...