Lesson 4: Navigating between SSRS reports (Tutorial)

Below tutorial describes how we can navigate (move) from one SSRS report to another SSRS report.

Add a new report “MainReport.rdl” 

Note: SampleReport should be created as first step as described in earlier posts.

Add a dataset, name “Title”, select checkbox “use a dataset embedded in my report” and insert the SQL query in the query. Click Ok.

The dataset is added successfully.

Drag and drop a table from toolbox into report designer.

Add column from dataset title into the table. 
Right click on the Title column and select option Textbox properties.

Textbox properties window will be prompted. 

Navigate to Action tab, select checkbox “Go to report”, select report “SampleReport” in the dropbox “Specify a report”. Then click Add button, select name as MovieTitle (parameter from SampleReport) and value as title. Click ok.

Then navigate to Font tab in textbox properties window and select color as blue and effect as underline. Do so the text will display as an hyperlink.

The click Ok.

Preview the report.

Click on the Title link in MainReport. You will be redirected to SampleReport with details for Title “Sangam” displayed.

Conclusion:

Simple example for navigating from one SSRS report to another SSRS report is complete.


Related topics:

Lesson 1: CREATE A SIMPLE SSRS REPORT (TUTORIAL)
Lesson 2: CREATE A SSRS REPORT WHICH EXCEPTS INPUT PARAMETER (TUTORIAL)
Lesson 3: CREATE DRILL DOWN VIEW IN SSRS (TUTORIAL)
Lesson 5: WORKING WITH SUB REPORT IN SSRS (TUTORIAL)
Lesson 6: WORKING WITH EXPRESSIONS IN SSRS (TUTORIAL)
Lesson 7: WORKING WITH GRAPHS AND INDICATOR IN SSRS (TUTORIAL)
Lesson 8: MISCELLANEOUS OPTIONS IN SSRS (TUTORIAL)