modifying the where clause during runtime in crystal reports 8.5 
Author Message
 modifying the where clause during runtime in crystal reports 8.5

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

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

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

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


Mon, 10 Oct 2005 21:09:14 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Crystal Reports 8.5 Runtime File List for VB packaging

2. Crystal Reports 8.5 (VB6) to Crystal Reports NET (VB.NET) conversion

3. vb .net crystal reports not compatible with Crystal Reports 8.5

4. Running Crystal 8.5 Reports on Crystal 9 RAS

5. Help - Trending report in the Drill-Down style in Crystal Reports 8.5

6. how can I transfer the report from Access2000 to crystal report 8.5 or VB6.0

7. Create execution file for report of Crystal Report 8.5

8. IIS 5.0 + Crystal Report 8.5 = Web reporting?

9. Using Crystal Reports 8.5 to Report Fields From Public Contacts Folder on Exchange 5.5 Server

10. How to refresh data in Crystal Report Object during runtime

11. Setting Crystal Reports Properties during Runtime Problem in VB

12. Crystal 8.5 Runtime script


Powered by phpBB® Forum Software