CODEWITHSUNDEEP
ssrs-2008reporting-services
Uneverno
Uneverno

Reputation: 49

how to redirect to particular report based on parameter selected in dropdown in SSRS?

i would like the user to redirect to particular report based on the parameter selected in dropdown. suppose i have a dropdown with names of 4 report names like A,B,C,D. if user selects A then the report A need to be displayed. Along with this 3 parameters which are common to all reports need to be passed. can this be done? aprreciate your help!!

Upvotes: 0

Views: 1841

Answers (1)

user359040
user359040

Reputation:

I don't believe this can be done exactly as you describe in SSRS alone, since redirecting to a particular report is an "action" - simply running one report is not an "action" in SSRS terms.

The following possibilities occur to me:

  • combine all four existing reports into a single report, with their displayed report objects conditionally suppressed based on the value of the report name parameter; or
  • instead of having a parameter for the report name, have a report with the other three parameters that displays report objects with actions linking to each of the four existing reports (essentially, this report would be a dummy report whose only purpose is to provide navigation to the other reports); or
  • write custom asp code to do this, instead of trying to do it in SSRS alone.

Upvotes: 1

Related Questions