Group Discounts available for 3+ students and Corporate Clients

Cascading Report

Cascading Report in MSBI


It  indicates that the parameter can have null values.


Allow Blank Value :

If we want to allow an empty string as a valid value then we have to set  This Parameter [Allow Blank Value doesn’t Support integer data type]

Cascading Reports :

In this Reports one parameter is depending on another parameter.  For examples 1 Country parameter and state parameter . If the user Select any country From the country Parameter then State parameter can be Run able and  display (or) Populate corresponding States .

At TekSlate, we offer resources that help you in learning various IT courses. We avail both written
 material and demo video tutorials. To gain in-depth knowledge and be on par with practical
 experience, then explore MSBI Training Videos.


Steps to Configure Cascading Report :

Open Business  Intelligence Development Studio and Create a new Report item and

Rename it as Cascading . rdl     ———–>

In Data tab create New Dataset and Rename it as category Details .     ———–>

Provide the following SQL Query

Select product category ID, Name as category Name from production . product category.     ———–>

Click ok     ———–>

Select New Data set and set

Name:  Sub category

Data source : D src product Category

Command type : text

Query string : Select product sub category Id, Name as

Sub category Name.

From production . product Category where product  Category ID  = @  product Category Id.

Click ok     ———–>

Select New Data set and set

Name : Product _details

Learn more about MSBI Interview Questions in this blog post.

Data source : Text

Query string : Select * from production .product


Product Sub Category Id = @ product sub Category ID.

Select Report menu and select ‘ Report Parameters ‘     ———–>

Select product Category Id . parameter and set in available values ; check  from Query

Radio button and

Data source : Category details

Value field :  product Category ID

Label field : Category Name

Select product sub Category ID parameter and set In available values:     ———–>

Check from Query radio button and

Data source : sub  Category

Value field :  product Sub Category ID

Label field : Category Name     ———–>

Click ok     ———–>

IN Layout tab design the Report     ———–>

Go to preview tab and Run the Report

For an Indepth knowledge on MSBI click on:

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at, we will update the article in 24 hours.”

0 Responses on Cascading Report"

Leave a Message

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


Please Enter Your Details and Query.
Three + 6