Debugging-an-RDP-class-based-ssrs-report-in-ax-2012
Follow the Given Steps:
1. In classDeclaration extend SrsReportDataProviderPreProcess instead of SrsReportDataProviderBase
2. Temp table properties should be
(a) Table type : Regular instead of tempDB
(b) Created by : Yes
(c) Created Transaction Id : Yes
3. In process report of the class add this line Temporarytablename.setConnection(this.parmUserConnection());
Now you Start debugging.
Common Error that occur in ssrs report :
Cannot edit a record in General journal entries that have not been posted (LedgerOpenTransactionsTmp).
The SQL database has issued an error.
SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated.
SQL statement: UPDATE T1 SET OFFSETACCOUNTNAME=T4.NAME,OFFSETLEDGERACCOUNT=T2.DISPLAYVALUE,RECVERSION=? FROM ...
Solution:
This Error Generally occurs when there is a mismatch in the EDT of the Fields in "LedgerOpenTransactionsTmp" Table.
Example:
Changing the field AccountName's EDT AccountName to DirPartyName will resolve this problem .or in some cases
Changing the field OffsetAccountName's EDT AccountName to DirPartyName will resolve this problem .
