Crystal Reports will allow you to report on the dataset.
>Hi
>I've connected to a datasource using ADO and OLEDB (on an Advantage server) but when I try to get the data into a cursor the access seems rather slow.
>
>This is my code to get at the data:
>cConnectString = [Provider=Advantage.OLEDB.1;]+;
> [Data Source=C:\TEMP\;]+;
> [Persist Security Info=False;]+;
> [Advantage Character Data Type=ADS_OEM;]+;
> [Advantage Server Type=ADS_REMOTE_SERVER;]+;
> [Advantage Table Type=ADS_CDX]
>oConn = CreateObject("ADODB.Connection")
>oConn.ConnectionString = cConnectString
>oConn.ConnectionTimeout = 30
>oConn.Open
>cSQL = "select * from sales"
>oRS = oConn.Execute(cSQL)
>
>The data goes into the RecordSet fine.
>
>Now I want to create a report on the data (n>1000000) but when I try to transfer it to a local cursor for reporting it only seems to transfer at around 100 records every 5 seconds!
>
>Can I REPORT FORM the data from the RecordSet without transferring to a cursor?