Add an ADO Recordset during DESIGN to a report

[LeonelSanchezJr]

I am trying to add the fields from an ADO recordset, which has already been created as "d:\temp\recs.rs", to my new Crystal Report during DESIGN TIME; NOT AT RUNTIME.

I am using VISUAL FOXPRO 6.0 to create the recordset and call Crystal. I do not want to create the report at run time. It is imperative that I create the report with the fields needed to receive the data from the RECORDSET.

I have been everywhere, but everyone uses Visual Basic and creates their reports at run time.

Again, I can not do either; the programming team that I am working with needs for me to do it this way.

I am sure there has to be a way to have Crystal recognize the recordset without having it created at run time.

Thank you for your time and assistance in advance.


Puzzled with recordsets.

 

[kenhamady]

I am not so sure that Crystal will recognize a foxpro recordset in a temp file. Crystal can read many formats of data from a disk, including some types of text files, but I do not believe that the FoxPro Recordset Temp file is one of the supported formats. As far as I know, Crystal can only read recordsets during runtime when the recordset is passed by the app to the report.

Can you save the data in any other format? Since you are in FoxPro, why not just write a temporary dbf to disk from the recordset? That is a format that Crystal can read. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal