Cascading input parameters

See more:

SSRS

Hi Friends,

I have created a report in SSRS 2008 (SP1). It has three input parameters (Division, Business Area, Business Unit). My requirement is when i select a value from Division, the corresponding business ares to be populated in the second drop down Business Area. When i select a value from this drop down corresponding business units to be populated. This works fine. But i have one more option given i.e "ALL". When i select "ALL" from Division input parameter, the subsequent input parameters (Business Area, Business Unit) to be defaulted to "ALL". But this is not happening. It may happen for the very first time the Division is selected to "ALL". But when i change the Division input parameter to some other value and select the "ALL" option again, only the next level is defaulted to ALL. But the business Unit is still having the previous set of values (basically not refreshed). Please help me to resolve this issue. When i select "ALL" option in the first level, the subsequent levels should be defaulted to "ALL".

Sample queries used:
Division:

Select divCode, divName from Divisions

BA:

select baCode, baName from BA where baDivCode = @divCode

BU:

select buCode, buName from BU where buBaCode = @baCode

Thank you,
Anand