Hi,
I have a few parameters that are to be passed to execute a crystal
report.I am using the pic list to enter the parameter.Lets say the pic
list has around 10 values, and I have chosen to pass multiple values
for a parameter.
For Example
The pick list has the values US,UK,AUS,IND,GER,FRA,NZ,CA,SI and ALL.
Lets say I choose US,UK,GER,FRA,CA then my query for the CR will be

Select countryName from Countries where CountryCode in
('US','UK','GER','FRA','CA')

and when I choose 'ALL' in the pick list then the querry should be as
follows

Select countryName from Countries

Another roundabout solution that I thot about is
when 'ALL' is chosen I want to pass all the values to the parameter.

Select countryName from Countries where CountryCode in
('US','UK','AUS','IND','GER','FRA','NZ','CA','SI')

Can some one help me????Awaiting someone's reply..........

Kart