Sriv
asked on
SSRS set Parameter value
In SSRS I have cascading parameter report. I have 3 parameters which have multiple values for example company , state , Products
When I select All for company it selects all the values for that parameter
Then I select all for States it selects all states
Then I select All for Products it selects all products
When I drop down and check company parameter I see that Select all and other parameters are selected
When I drop down and check State parameter I see that Select all is unchecked but all parameters are selected
When I drop down and check company parameter I see that Select all and other parameters are selected
What can I do to keep Select All option checked for states parameter.. I need select all checked because when I preview report I dont want to display all states .. I just want to show All as other parameters
When I select All for company it selects all the values for that parameter
Then I select all for States it selects all states
Then I select All for Products it selects all products
When I drop down and check company parameter I see that Select all and other parameters are selected
When I drop down and check State parameter I see that Select all is unchecked but all parameters are selected
When I drop down and check company parameter I see that Select all and other parameters are selected
What can I do to keep Select All option checked for states parameter.. I need select all checked because when I preview report I dont want to display all states .. I just want to show All as other parameters
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER