cjmorris1201
Programmer
Hello,
I am relatively new to my company and to crystal reports as well. I need help. I hava recently been tasked to perform a test using a ADO.NET dataset and Cystal Reports 8.5.
Currently we use v8.5 reports designed on Data Defination Files (TTX files). The data is fed to the reports using the PUSH method (ASP, VB) and ADO recordsets and then the reports are exported to PDF. No problems there.
However, I have been asked to use these same reports using a dataset from ADO.NET. The code seems to work correctly until the file is exported and a "File not found" COM exception error occurs.
My question is: Can Crystal Reports 8.5 even be used with datasets? I googled the web and searched Business Objects with sure method. I set the DataSet table name to the report's data name and verified that the column names are identical as well.
ds.Tables(0).TableName = reportDB.Tables(1).Name
reportDB.SetDataSource(ds)
Perhaps I'm missing some other steps. Any help would be appreciated. Good or bad news.
Regards,
Carl
p.s. btw, we do not use crystal reporter viewer nor forms. Our application is web-based and we use ASP to display our content and acrobat reader for the reports.
I am relatively new to my company and to crystal reports as well. I need help. I hava recently been tasked to perform a test using a ADO.NET dataset and Cystal Reports 8.5.
Currently we use v8.5 reports designed on Data Defination Files (TTX files). The data is fed to the reports using the PUSH method (ASP, VB) and ADO recordsets and then the reports are exported to PDF. No problems there.
However, I have been asked to use these same reports using a dataset from ADO.NET. The code seems to work correctly until the file is exported and a "File not found" COM exception error occurs.
My question is: Can Crystal Reports 8.5 even be used with datasets? I googled the web and searched Business Objects with sure method. I set the DataSet table name to the report's data name and verified that the column names are identical as well.
ds.Tables(0).TableName = reportDB.Tables(1).Name
reportDB.SetDataSource(ds)
Perhaps I'm missing some other steps. Any help would be appreciated. Good or bad news.
Regards,
Carl
p.s. btw, we do not use crystal reporter viewer nor forms. Our application is web-based and we use ASP to display our content and acrobat reader for the reports.