Monday, April 27, 2015
   
Text Size
Login

SSRS Redirect after a report is run

What?
This article serves to describe several workarounds or proofs of concept.

Why?
We have a first report which acts like a search page. You enter the student you are looking for by reference or name and if there is only 1 result in the results page, then we want it to redirect to the details report for that student automatically.

How?
So there are various solutions out there, here's an overview of some:

Method #1
  1. Create one report with all selectable reports as subreports - toggle visibilty based on parameter.

Method #2
  1. Add a button below "View Report" linked to some script code (requires change to ASP pages on the ReportingServer, ie. affects all reports on that server).

Method #3
  1. Use ASP instead of SSRS.

Method #4
  1. Use a TimeInterval refreshing the page after a certain time.

Conclusion
In the end, this came down to a design decision. Time spent on trying to find a solution was not considered to be warranted. My reports use a parameter for the connection string to specify which server and database to connect to and the follow on link was enough as a solution. My seniors advised that if we had time in the future we could expand on this further.


Google Searches that got me nowhere:
  • ssrs process parameter after report execution
  • auto-redirect after are a report is run
  • ssrs vbscript post report processing
  • ssrs auto redirect based on a dataset value

Comments   

mario
# mario Thu, 27th September 2012
Did you figured it out?
Like | Dislike | 0 Reply | Reply with quote | Quote
Add Comment

Name:

Email:

Website:

Message:


Help Develop!

Thank You! :c)



Connect: Google+

Visitors of the World

Latest Posts

  • Basic Android App using Google Maps and Current Location

    • Wed 22-Apr-15
      Hi, It's there a way to capture the directions the Gmaps navigation gives you? Like, when you have ...
      Neno
  • Joes Quicklist Weblinks (JQW)

    • Thu 23-Apr-15
      I changed the sourcecode in the helper.php file at line 249 from $ch = ...
      Andy  
    • Thu 23-Apr-15
      Joomla 3.4.1 purity iii template
      Andy  
    • Thu 23-Apr-15
      Hi, I got on all my weblinks a black thumbnail with this error back: http%3A%2F%2Fwww.deutsche-wirtschafts-nachrichten.de ...
      Andy  
    • Thu 23-Apr-15
      Hi, I got on all my weblinks a black thumbnail with this error back: http%3A%2F%2Fwww.deutsche-wirtschafts-nachrichten ...
      Andy