Crystal Reports

[Guest]

Hi All

I would like to pass the following sqlStatemet to Crystal Reports, as the
statemet to retrieve records :

SELECT Emp_Name,Emp_Surname,Emp_Number FROM Employees WHERE Emp_ID = @Emp_ID

The Emp_ID is chosen from a combo box on the form that has my crystal viewer
control on it.



Thanks

Christopher

 

[Bruce Wood]

We're doing this a bit differently: we do the data retrieval in .NET
and pass the data into Crystal as ADO.NET DataSets. This is more
involved than what you're talking about, because it changes the way
that the report works from a pull (Crystal retrieves the data) to a
push (data sent to Crystal) mechanism, which changes the way you have
to build the report templates.