One team or all teams grouped depending on parameter 2

[amasny]

I made report including team column from tema table.
I would like have report which will show me data for one team
depending on ?team_name parameter if team name will be choosen or showing records for all teams if i will choose
"all" item contained in may parameter list.

 

[GJParker]

Try this in the selection formula

if {?team_name} <> &quot;all&quot; then {Table.field} = {?team_name}

HTH

Gary Parker
Systems Support Analyst
Manchester, England

 

[IdoMillet]

Gary's suggestion is correct.

You may get better performance with the equivalent condition of:
--------------------------------------------------------
({?team_name} = &quot;all&quot OR ({Table.field} = {?team_name})
--------------------------------------------------------

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[amasny]

Very thanks Gary and Ido. This helped me.
I've added this in record selection formula but in modified form and it works :
if {?team_name} <> &quot;all&quot; then {Table.field} = {?team_name}
else true.
I'm beginning crystal programmer.