Creating reports and dashboards | Stimulsoft community forum

Hi a made a report with dotconnect for oracle dataprovider .
The connection its ok (But in build connection form it throws exception in test and checked the direct mode)
When i try to add a datasource for that connection if in the datasource add parameter
like select * from HR.EMPLOYEES the result it fetches correct data from oracle.
When thw query add a parameter like
select * from HR.EMPLOYEES where EMPLOYEE_ID =:ID
and add then paramater called :Id it throws exception
cannot conver 'Devart.Data.Oracle.OracleDataAdapter' to 'System.Data.SqlClient.SqlDataAdapter'.
Any suggestions ?
Best Regards
Efh.

Hello,

Please clarify which version you are use?

Thank you.

Devart.Data.Oracle 8.5.464.0
Stimulsoft Reports.Net 2015.1
adapter DotConnectOralce 23/4/2015
Regards

Hello,

Please check the Stimulsoft.Report.DotConnectOracle in the attachment.

Thank you.

Yes .
Now Works Perfect.
Thank You.

Hello.

We are always glad to help you.
Let us know if you need additional help.

Thank you.

Hello
With this provider
when a parameterin select clause is datetime it throws error
SELECT
EMPLOYEE_ID, START_DATE, END_DATE,
JOB_ID, DEPARTMENT_ID
FROM HR.JOB_HISTORY
Where trunc(END_DATE) > trunc(:d1)
and add ParaMeter d1 (date)
unable convert datetime to int16

Hello,

Can you please send us a report template for analysis.

Thank you.

in attachment

Hello,

Please check the Stimulsoft.Report.DotConnectOracle in the attachment.

Thank you.