Search This Blog

Back to Previous Report or Parent Report in SSRS

Back to Previous Report or Parent Report in SSRS

Many times when working with multiple reports on clicking a link on a report you are navigating to other report and clicking on child reporty you want to go back to your parent report .
Then below Javascript you can use.

Back to Previous Report or Parent Report in SSRS
Add a Image or Text box in your Report 
In below back  image i have added an Image GO to TextBox or Image Properties.
Action-Go to URL
="javascript: history.go(-1)"




If you want to go to more back then replace -1 with -2 to go back upto 2 levels, -3 to go back 3 levels and so on.

Another way is like

 In  back  image i have added an Image
 GO to TextBox or Image Properties.
--Earlier we use Go to URL Now using Go to Report
Action-Go to Report-Select your Report from DropDown
Ok 
Clicking on backimage or Textbox willl Navigate to report selected from dropdown.

NOTE:
1-If you are opening page in a Sharepointwebpage and ="javascript: history.go(-1)" will not wok until u have a separate webpage for each report as through one web page you are navigating to other childs report then in order to go back to parent report remove -1 from javascript.
="javascript: history.go()"

2-When using Javascript function to go to parent report or previous report enabled javascript in your browser 
Steps to enable in Internet explorer.
  1. On the Tools menu, click Internet Options, and then click the Security tab.
  2. Click the Internet zone.
  3. If you do not have to customize your Internet security settings, click Default Level. Then do step 4
  4. If you have to customize your Internet security settings, follow these steps:
    a. Click Custom Level.
    b. In the Security Settings – Internet Zone dialog box, click Enable for Active Scripting in the Scriptingsection.
  5. Click the Back button to return to the previous page, and then click the Refresh button to run scripts.
For other browserrs see Microsoft link-http://support.microsoft.com/gp/howtoscript


12 comments:

  1. Hi. I use ="javascript: history.go(-1)" in all my drilldown reports but with the Edge browser it does not retain the parameters. Have you encountered this?

    ReplyDelete
  2. I recently found many useful information in your website especially this blog page. Among the lots of comments on your articles. Thanks for sharing. Sandy Hook Parent

    ReplyDelete
  3. I’ve been searching for some decent stuff on the subject and haven't had any luck up until this point, You just got a new biggest fan!.. 릴게임

    ReplyDelete
  4. Cool stuff you have got and you keep update all of us. test bank nursing

    ReplyDelete
  5. The advantage of JavaScript is that Client-side JavaScript is very fast because it can be run immediately within the client-side browser. Unless outside resources are required, JavaScript is unhindered by network calls to a backend server. JavaScript is relatively simple to learn and implement. Whether you are looking to market a new business through JavaScript Programming or become a professional JavaScript developer Live Training Lab has a course to help you achieve your goals. free SQL Server courses

    ReplyDelete

  6. Usually I never comment on article but your article is so convincing that I never stop myself to Real Leather. best chihuahua puppies for sale chihuahua puppy for sale, tea cup chihuahua puppies for sale, chihuahua puppies for sale near me, sphynx cats for sale

    ReplyDelete
  7. Nice. Keep writing such beautiful blogs. In 2022 a little bit of change will be done in the Turkey visa price . That changes may differ as per the differ country status . Read all the updated info related to the turkey visa.

    ReplyDelete
  8. Nice blog, Very interesting!! Thanks allowed me to comment in here.. What is e visa Indian? India e-Visa is an electronic authorization to travel to India for business, tourism, or medical visits. Apply for an e visa to India through online eta Indian e visa official website.

    ReplyDelete