John
Thanks for the advice about Crystal and ADO. I've been trying to get Crystal to pick up my record set through a Crystal definition file (TTX). I'm not far off but when I print the report all I get is the report headers and not the report detail. The total record count for the report is the correct number of records, but when these are exported to a text file, the result is the report header duplicated for the number of records in the table.
The commands I'm using to set the whole thing up are:
oConn = CreateObject("adodb.connection")
oRS = CreateObject("adodb.recordset")
oConn.Open("DSS")
oRs.CursorLocation = 3
oRs.Open("Area",oconn,3,1,2)
oCrystal = CreateObject("Crystal.CRPE.Application")
oReport = oCrystal.OpenReport("c:\datanew\area.rpt")
oReportDB = oReport.Database
oReportTables = oReportDb.Tables
oReportTable = oReportTables.Item(1)
oReportTable.SetPrivateData(3,ors)
oReport.Preview
Have you any pointers how I might get this working?
Thanks
Anthony
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only