Devart Forums

I am designing XtraReports using dotConnect for Oracle provider. I started by creating a simple oracleDataAdapter on the designer of the report and then generated a DataSet.

I then assigned a DataSet to the datasource of XtraReport. For some reason I cannot preview the report nor I can view the report in the runtime.

However, devexpress support asked me handle BeforePrint event of the XtraReport and then reassign the dataset as a datasouce to the report. Which seems to work in the report run time, but the preview mode of the report still does not work.

however, using normal SQLDataAdapter and dataset does not have any of the above problems.

Can some advice on the issue with dotconnect for oracle and devexpress xtrareports?

Have you set the DevartDataSet.YourTable.Active property to True in the design time? Please send us a small test project with the scenario which works with System.Data.SqlClient, but doesn't work with dotConnect for Oracle. Also please specify the versions of the DevExpress controls and dotConnect for Oracle (x.xx.xx) you are using. You can find the version of dotConnect for Oracle in the Tools | Oracle | About menu of Visual Studio.

Shalex wrote:Have you set the DevartDataSet.YourTable.Active property to True in the design time? Please send us a small test project with the scenario which works with System.Data.SqlClient, but doesn't work with dotConnect for Oracle. Also please specify the versions of the DevExpress controls and dotConnect for Oracle (x.xx.xx) you are using. You can find the version of dotConnect for Oracle in the Tools | Oracle | About menu of Visual Studio.

I could not fine DevartDataSet.YourTable.Active property in the design time. Can you direct me where I can find that?

We have reproduced the problem, we will investigate it and notify you about the results as soon as possible.

We have investigated the issue.

1) DataSets created using Devart DataSet Wizard cannot be used by XtraReports. The reason is that XtraReports create a class that inherits System.Data.DataTable but try to bind it the fields specific for Devart.Data.Oracle.OracleDataTable. The last class is the ancestor of data tables used in DataSets created by the Devart wizard.

2) It should be possible to use DataSets created with MS DataSet Designer. If you are encountering any problems with this, please send us a test project with which the problem can be reproduced.

1) DataSets created using Devart DataSet Wizard cannot be used by XtraReports.

New build of dotConnect for Oracle 5.70.152 is available for download now.
This version includes:
* Fixed bug with DataTable in design time when using DevExpress XtraReport

Does it mean, that with 5.70.152 I can use XtraReports ?

Yes, we have fixed the problem that was associated with the Unable to cast object of type 'DevExpress.XtraReports.UI.XtraReport' to type 'System.Windows.Forms.Control' error. Please try the 5.70.152 build of dotConnect for Oracle.