How to create a group,

[BilboB]

I want to creat a single parameter value that selects a number of different values from a particular field.
e.g. I want to select "team", but I only have staff names and not team in my database.

Help!?....

 

[kskid]

It would help greatly if you include in your post

Crystal Version
Database and connection
Sample input data
expected output

Based on what you stated, are you wanting to select staff names to be part of a "Team" or do the staff names already belong to a "Team"?

If you want to assign staff names to a "team", then
//@TEAM
Select {table.staffname)
Case "JOE NAMATH" : "JETS"
Case "MATT SNELL" : "JETS"
Case "JOHN UNITAS" : "COLTS"
Case "PAUL WARFIELD" : "COLTS"
Case "DARYL LAMONICA" : "RAIDERS"
Case "FRED BELITNOKOFF"" : "RAIDERS"
DEFAULT: "UNKNOWN"

Insert a group by {@team}

GH1 COLTS
D JOHN UNITAS
D PAUL WARFIELD

GH1 JETS
D JOE NAMATH
D MATT SNELL

GH1 RAIDERS
D DARYL LAMONICA
D FRED BILETNIKOFF

Hope this helps

- Larry
This will allow you to gro

 

[kskid]

Ooops.... Forgot to create the parameter and selection

From the field explorer, create a parameter, team.

Click on the set default values and add the team names you set up in @team (i.e. COLTS, JETS, RAIDERS).

In your your record selection formula (select expert), enter

{@team} = {?team}