Parameters that depend on another

I have a situation where I need to create the same graph for 4 "levels". The problem I am facing is that each subsequent level depends on its parent, and I require a parameter (@.Level) to indicate which level of the report to create.

For example, if a user wants to view a report for the 'grouping' level then they would select the grouping from a drop down list and @.level would be set to 1.

Now, if the user wanted to view a report for the 'subgrouping' level, then the user would first need to select a grouping. Once this is done, the subgrouping drop down would become enabled and the user would then select a subgrouping to the grouping (ie. filtering based on the first dropdown menu).

If the user does not select a subgrouping, then the value of @.level should be 1. If the user does select a subgrouping, then the value of @.level should be 2.

The datasource for this report is a stored proced that accepts the @.level paramter as well as the ID of the object choosen from the drop down menu.

Is this possible to do? If so, how would i go about creating the sequence which the parameteres are entered and determin which level is selected?

Thanks for any and all help.

Ben

Ok, I figured out that when one parameter excepts another parameters value as its input, it is disabled untill the required parameters are selected.

I still need help figuring out how to know/set the value of @.level based on which parameters have been chosen.

Thanks.

Ben