Problem Solved! :-)
If you use the Active Data Driver (using the relevant flavour, ADO for the following example) to develop the report, and save it as a .rpt file (with or without the data), you can then use the following code to populate a recordset and point the report at it. you can then...
Stephen, the oRpt.DiscardSavedData method causes the parameter entry dialog to pop up. I had tried this before to no avail.
Ken, the oRpt.DiscardSavedData achieves the same thing, I had intended to save the report without data when I got
all this working.
I have since found out the following...
I'm trying to populate a report with an ADO recordset.
The following code is what I have so far.
Dim oApp As New CRAXDRT.Application
Dim oRpt As CRAXDRT.Report
Dim rsResults As New ADODB.Recordset
Set oRpt = oApp.OpenReport("c:\MyReport.rpt")
PopulateRS rsResults
'...
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.