I have a SQL table, "OUT_Table" which has around 50k rows. There are few columns (Region, Sub-Region, Country, Channel etc) which are a part of the table which i am using in SSRS as parameter.
Now, the client wants me to make the parameter, multi.
and they also want, "All" and "None" on each parameter.
for All, "Select Distinct Region from OUT_Table" will give me all data, however how do i do that in multi level?