Display an expanded drill down report by default initially but should collapse based on the parameters selected in ssrs -

i create report expanded default when first run. eg : using 3 fields in dataset- country,state,city first group country, second group state , details group city. groups of tablix , created in stepped style report want create drill down report toggle.

the problem - have 3 parameters - summary,intermediate,detailed. when user selects summary parameter, country field displayed toggle when clicked, expands state column , toggle in state column when clicked expands city column, , can collapsed clicking on toggle.

when user selects intermediate parameter, country column , expanded state column should displayed when report run, , toggle on state column should take me city column , can collapsed clicking on toggle.

similarly, when user selects detailed parameter, of 3 columns should displayed in expanded state when report run , can collapsed clicking on toggle.

how can achieve this?? have tried number of ways no luck.

please me..

thanks

this called cascading parameters. want use separate datasets each parameter. use country parameter in dataset state , use state parameter in city dataset.

select distinct state yourtable country = @country  

for more info, check https://technet.microsoft.com/en-us/library/aa337498(v=sql.105).aspx