Configuring a cascading parameter for SSRS report is easy. We used to play with multiple datasets. To make it simple, if we have two parameters in a report, the second parameter values are based on first parameter selected value.
I have following two parameters in a report.
Country Parameter will show all the available country and city parameter will show all the cities irrespective of country. In a business scenario, this needs to be fixed as users will expect to see only cities relevant to the countries.
If user Selects India, then the city should show only the cities from India.
Check out my below post for cascading parameter in SSRS report.
The same logic can be applied in SSRS mobile report but with different procedure.
In this scenario, I am taking AdventureWorksDW database for better understanding.
Follow the below steps,
Step 1: Create a shared Dataset and deploy to report manager.
Step 2: Open Mobile report publisher and add the shared dataset. In this case dataset from AdventureWorksDW database.
Step 3: Drag and Drop two selection list. You can maximise or minimise to show only one value at a time as like below.
Step 4: Go to Data and Add data. Here I added a shared dataset which contains Product Category Name and Product Subcategory Name fields.
Step 5: Rename the Selection list 1 to Category and selection list 2 to Sub Category
Step 6: Choose our dataset for both the selection lists. Make sure to choose Category Key and label for selection list 1 and Subcategory Key and Label for selection list 2.
Step 7: Add the checkbox on “Filter these dataset when selection is made”. Choose the Product Category.
Step 8: Click the options on subcategory data, choose Category check box under “Filtered by”
Step 9: By default “Allow select all” option is ON, now off for both the selection list.
Step 10: Preview the report. You can check the sub category shows only Bike information. If we choose some other value in category then it will show respective sub category results.