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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reports 10.05.1609; SQL Server 2008R2 - Multiple Parameter, create new code to group several

Status
Not open for further replies.

hmax

Programmer
Jan 22, 2012
60
0
0
US
Crystal Reports 10.05.1609
SQL Server 2008R2

Crystal Reports - multiple drop-down parameter, create new code to group several drop-down codes together.

Example:

Parameter Multiple drop-down
Code Description
AA Language A1
TQ Lanugage A2
WR Language A3
SP Language B1
DF Language B2
GK Language B3

The user can choose one or multiples from the drop-down parameter.

Now, I need to create a new code to group together, for example, all A languages, e.g., new code might be CL, containing (AA, TQ, WR).

Thanks in advance for your help.

 
( ({?parameter) = 'CL' and {table.language} in ['AA','TQ','WR']
OR
({?paremeter} = 'XX' AND {table.language} in [ list of codes ])
or {table.language} = [?parameter} )
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top