SSRS

[General]

Questions:

Notes:

What is a Shared Data Source?

A Shared Data Source is a data source connection string that is shared by all the reports in the project.

What is a Data Set?

Query used to retrieve the data to be shown in the report.

What are Shared Data Sets?

Share Data Sets are data sets which can be used by multiple reports.

What are Parameterized Reports?

Parameterized Reports are reports that include parameters in them.

 

These parameters can be applied to different functionalities. Such as using the parameters as a search predicate for your report table.

 

Also, you can use a select statement to populate these parameters with “available values”. In the report viewer, the user will see the parameter as a dropdown box that pulls available values from the select statement.

What are Cascaded Parameterized Reports?

Cascaded Parameterized Reports are reports that use multiple parameters in them.

However, some parameters will depend on other parameters for their values or value sets.

 

The order of parameters can change the optimization of the report. For example, if we have a customer parameter that has million results it can be filtered by first having the gender parameter, which will cut the customer parameter results in half.

 

For example, we have a subcategory parameter but its values aren’t populated until the category parameter is chosen.

What are Drill Down Reports?

Drill Down Reports are reports that have hierarchies within their rows or columns.

 

They take advantage of expanding pivot tables to give the user aggregated data that can be expanded to show greater detail.

Leave a Reply

Your email address will not be published. Required fields are marked *

Name *