Parameter and grouping question

[Crystalyzer]

I am using CR XI.

I have a report that I am grouping on User Name as the 1st level grouping. I would like to include a parameter for user name and include an option to select ALL Users. I would also like the option that IF ALL users are selected that the grouping should be either shown (so that individual users appear in their appropriate group header) or hidden (all users data is combined into an aggregate report and the users grouping is not shown.)

CAn anyone direct me?


Thanks and best regards,
-Lloyd

 

[synapsevampire]

Create a string parameter and set the default value to "ALL"

In the record selection formula place:

(
if {?MyParm} <> "ALL" then
{table.field} = {?MyParm}
else
if {?MyParm} = "ALL" then
true
)

You can add in another parameter to use as the suppression for the group header and footer.

-k