Problem with parameter selection.

i have a first parameter where user can select either office or hometown selection. based on this selection i have two more paramters in which only one should be populated and the other should be disabled.

i was able to manage to do it, but when i veiw it in the report viewer the problem is its not populating the values for other one which is supposed to be at the same time it says select a value in that combo and report doesn't execute bcoz of this.

any help.

parameter1 choices : office, hometown.

parameter2: will be populated if office is selected

parameter3: will be populated if hometown is selected.

is there a way to disable completely upon selection of the first one.

Thanks

Kishore.

Hi,

for the second parameter if you are using the stored procedure then pass the first parameter value i.e Parameters!Param1.Value,to do this in the dataset of second parameter(ds2) click on Parameters tab,value:Parameters!Param1.Value.This will automatically populate the second parameter.And coming to the Report->Parameters->Param2->Available values From ds2.

Hope this helps

I

|||

Thanks for the reply,

I am able to do that. but the thing thats bothering me is in the report viewer, i cant run the report without selecting all the parameters, in my case here what ever the user selects by home or office.. accordingly the combo box is populated and the other one shouldn't and its doing it but the problem is when i run the rep in viewer, its asking me to select a value for the no populated box. the report wont execute if i leave it like that.

thnks.