Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter and grouping question

Status
Not open for further replies.

Crystalyzer

Technical User
Mar 28, 2003
218
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top