Prompts based on Parameter values

[northw]

Hello all,
I have question about grouping based on parameters. In my reports I have dynamic cascading prompts, where a user can select a region, based on the region user will be provided with options with the selected region, suppose if the user selects region A and has three values in the region 1, 2, 3 then the user can select one or two or all three values. Based on the selected values I have to group the data, If the user selects only two values 1 and 2, I have group data in the report on 1 and 2 like wise if user selects 1 I have to be able to group only on 1 same thing if the user select all three values.

Any thoughts to achieve this?

Thanks in advance!

 

[northw]

Sorry, I named the post inappropriately.

Groups based on prompts.

 

[lbass]

Are you saying that you are not limiting the regions and values in the record selection formula, but ONLY in the grouping, so that there would be some other group for all records that don't fall into the selected groups?

Otherwise, you just need to set the parameters equal to the corresponding fields in the record selection formula and then group on the fields without reference to the parameters.

-LB

 

[northw]

Thank you Lbass!