The reason I need to pass a recordset is that I've got several field selection criteria from the users, and have translated/embedded these into the SQL statement during the recordset creation.
In short, I've got FILTERED data that needs to passed into the report. Without going thru parameters...
Thanks Balves for your reply.
I got rid of the 1 at the SetDataSource Statement
I got rid of the .ReadRecords
I retained .DiscardDSavedData
Reran the job, still the same result.
I created the report using Crystal Report 8. (The Application Not with VB) I created it using Report Expert and...
What I need is to create the SQL and DB connection within VB based on Users input
and pass this SQL into an .RPT file and populate the report.
The .RPT file was created using Crystal Designer Version 8.5 outside of VB.
The .Rpt file have all the liked tables defined and there is an SQL...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.