I am having 4 Report parameters and these are linked with the 4 datasets individually. All 4 parameters are hierarchically linked. For eg: Country-->State-->City-->Town. I need to select a Country name firstly and then automatically it has to filter the next parameter list(State parameter) by default 'ALL' and also manually it has to allow me to select 'single' state. Likewise city, town too..
I tried with stored procedures :
State = IIF(@State='0',State, @State) , similarly the other two as well.
This is giving me results in SQL but not allowing me to select single parameters without default value under country parameter in BIRT.
Please help me in this as it is an immediate requirement.