Quick question...to eliminate a variable. Have you tried doing the same sort of thing with an access database??? I just want to eliminate VFP as a possible issue...




>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