Reporting Services (SSRS) Part 17 - Linked Reports

Refer Source Video :Reporting Services (SSRS) Part 17 - Linked Reports

Linking Reports using Tables:

- Designing the Basic Reports

-Creating Parameters

-Applying Filters

*

Creating Links Using Other Items:

- Adding Actions to Charts

- Creating a clickable WorldMap

-Linking to Reports using a Matrix

*

What is  the Linked Report?

Creating a Parameter

Parameter:

 Applying Filters:

DataSet

 -DataSet Properties

              Filters

              Expressions:

              Value: <- specify the parameter

*

Assigning the values to the Table

Textbox properties:

       Action

             Go To Report

                  Specify a report

                  Use these parameters to run the reports

                  Add

                  prmCountryID  CountryID


note:Action just not only to the a text box, it can be on any object, (Chart etc.)

*
Creating Links using Charts:

Chart Data

Values:

FilmBoxOfficeDollars
[Avg(FilmBoxOfficeDollars)]


Category Groups:
[CountryName]

Series Groups:


Right Click on the Chart :

 Choose "Series Properties"

   Action:
      rest all the same.

*
Creating a clickable Map:

Table & Chart ( Action : example is shown )

Polygon Layer:

     Polygon properties:

        Action

                Go To Report
                           (all same ...)
                        Can not choose the value directly ( Expression )


*
Passing values to Multiple Parameters:

example: Matrix report

Parameter:

  prmCountryID
  prmCertificateID

DataSet:

     properties

        Filter


other report:

    textbox
          Action: Go To Report

            Use these parameters

                 Add

                     prmCountryID
                     prmCertificateID