SSRS (SQL Server Reporting Services)Real Time Scenarios:
Scenario 1:
Show the report like Drill Down. Here I have 3 groups as shown in below.
Main Category Name
+ Sub Category Name1
+ Sub Details1
Details1Name rate qty amount
+Sub Details2
Details1Name rate qty amount
+SubDetails3
Details1Name rate qty amount
+SubCategory Name2
+Sub Catagory Name3
.....
Scenario 2:
I have an SSRS Report that needs to be filtered via multi-value parameter selection. normally we can done for single column. But here we want to allow multi-select based on multiple columns. The column layout is as follows:
AFLAG BFLAG CFLAG DFLAG
X X X X
NULL X NULL NULL
X NULL X NULL
X X X X
X NULL X NULL
NULL X X NULL
X X NULL NULL
X X NULL NULL
In my report parameter, when multiple AFLAG, BFLAG, CFLAG or DFLAG values are selected, I want to be able to display every Reports that contains an 'X' in each column once, where there are multiple values marked with 'X' in a single report.
Scenario 3:
