I have 2 parameters in my SSRS report.
First parameter (Business) is a multiple select and I call a SP to populate it. I do not default into this parameter
Second parameter (Directors) is a multiple select and I call a SP to populate it. I call the same SP again as a Default so this parameter is populated and all Director names are checked. I pass the Business parameter to this parameter so I know what directors to find.
On the first pass thru the report, all the Director names that belong to the first Business checked in the Business parameter are in the Directors parameter and they are all checked.
If I choose another Business in my first parameter (Now I have 2 checked) my second parameter will now show additional Director names but these names will not be checked. Is there a way to get these additional Director names checked (automatically) like what happened on the first time thru.
Looks like the Default SP only runs once and after that you have to manually click dropdown and check off these new Directors.