When trying to run Accrued purchases report in AX 2012, I modified SysQuery by clicking on Select button and then adding a datasource by right clicking on the table and selecting 1:n option. After doing this, I am unable to run the report and continuously getting the below error:
Cannot select a record in Purchase orders (PurchTable).
The SQL database has issued an error.
SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting date and/or time from character string.
SQL statement:
I tried everything to resolve this issue, but no luck. When I set the Dynamic filter for the datasource to False in Visual Studio and redeploy the report, the report runs fine. So I suspect adding the datasource under SysQuery form produced this issue. I am trying to remove the datasource I added, but each time I open the SysQuery form using Select button, the datasource is showing there. I also deleted the record from SRSReportQuery table and delete, redeploy the report, cleared cache but still I am getting this error.
Can anyone please let me know how to resolve this error?
