How to pass Join table recordset to crystal report 7

[cfkeem]

Hi,

1. I’m using Crystal Report 7 with VB6 currently.
2. I would like pass a Recordset/ SQL to DSR Crystal Report with Join table, for example is:

Select Order.No, Order.OrderDate, Supplier.Name, OrderQty
From Order Join In Supplier on
Order.SuppID = Supplier.SuppID

3. Do you know how should create a datasource during creating crystal report and how could I pass the recordset or SQL command to Crystal report on VB form?

4. Thank you.

Regards,

Steward

 

[kenhamady]

You can either create a TTX file to use while designing the report, or you can connect the report to the live data using the Active Data Driver. Either of these will allow the report to accept a recordset in your app.

Make sure that the recordset is built with the exact same fields, in the exact same order.

You pass the recordset using the SetDataSource command. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com