Passing Query from VB

Guest_imported · Apr 15, 2002

How can I dynamically pass the Query for sql report from the VB( Ex- select * from Employee_details where date1="&quot

Now I want to pass the date from the Front-End .

How can I do that

Thanks
Anil

Aristophil · Apr 15, 2002

1. You can use ActiveData as your data source for the report, in which case you can pass a recordset to Crystal, e.g.:

Code:

rs.Open &quot;SELECT * FROM MyTable&quot;
rpt.SetdataSource rs, 3, 1

2. You can specify a record selection formula and filter the table for a specific date, e.g.:

Code:

rpt.RecordSelectionFormula = &quot;{Data.MyDate}=&quot; & Chr$(34) & strMyDate & Chr$(34)

(Chr$(34) is the double-quote character).

3. You can set up a parameterized stored procedure and pass it a parameter, e.g.:

Code:

rpt.ParameterFields(1).AddCurrentValue CDate(strMyDate)