Grouping on Multiple Parameter or Container Report Grouping 1

[alembong]

CR XIr2
Here's the scenario: I have a container report that is passing a parameter indicating what type of exceptions to display. The options are All, In Service, Barcode or Costs. I'd like to be able to display a different subreport for each exception type that the user chooses or all subreports if they select All.

I have no problem putting each subreport into a RF section and suppressing conditionally depending on the parameter value. What I would like to do is Group by the Exception Types so that the user has a group tree to click on if they select more than one exception.

I've thought that I could either
- set up the parameter so that it only allows multiple (and to select All they would need to add all types) and then somehow use those as groups. I get an error that says "Group specified on a non-recurring field"

or
- Group on a text field that is not based on database data. The reason that I don't think I can base the group on db data is because doing an "If..then...else" would not be inclusive if a record satisfies more than one exception.

Hopefully, that explains what I'm trying to do. Let me know if I can supply more info. Any help would greatly be appreciated.

 

[lbass]

You can't group on parameters. You could group on the exception type field in the main report, and then place one sub in a group header section and suppress other report sections. Then link the sub to the main report on the type group field. Because the sub records are independent of the main report, a record could appear in more than one instance of the subreport, if it met your criteria. Use the parameter only in the main report record selection formula.

-LB