SQL 2000 ADO RECORD SETS, VFP 6.0 & CRYSTAL REPORTS 8.0 1

[LeonelSanchezJr]

I AM CREATING AN ADO RECORD SET FROM SQL 2000 VIA VFP 6.0 AND TRYING TO VIEW / PRINT A REPORT IN CRYSTAL 8.0; DOES ANYONE HAVE AN IDEA HOW I CAN DO THIS?

 

[BlindPete]

Try reading faq184-306 by FoxDev
-Pete

 

[foxdev]

Why not pull the data directly from SQL Server with Crystal Reports?


Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org

 

[LeonelSanchezJr]

FOXDEV:

The reason I don't pull the SQL 2000 query directly from Crystal Reports is because I have to use Visual Foxpro 6.0 as my my front-end. This is a must.

Thank you for your time and consideration.

 

[foxdev]

Then I guess I'd go with the simplest solution involving all three products. Rather than using an ADO recordset, pull the data from SQL Server into a cursor, then write that out to a DBF, then have Crystal Reports use that static DBF for the report.
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org