I have a report with 1 command object that originally connected to an ODBC datasource. I would now like to connect using an ADO dataset. Here is my code.
myReportsDocument.Load("c:\goldfish.rpt")
...set up dataset.ds
myReportsDocument.SetDataSource(ds)
myReportsDocument.ExportToDisk(ExportFormatType.PortableDocFormat, "C:\goldfish.pdf")
I've also used myReportsDocument.Database.Tables(0).SetDataSource(ds) at line 3 to no avail. No matter what I do it seems to want to point to the ODBC connection. How can I point it to the dataset instead?
The ado dataset is pointing to an oracle database using System.Data.OracleClient.
Thanks in advance,
J
Edited by: Jason Cameron on Mar 10, 2009 3:36 AM
Edited by: Jason Cameron on Mar 10, 2009 4:41 AM (added data location of dataset)