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