CreateTransactionID is coming 0 (Zero ) Table for SSRS Report

Finance and Operations/AX Developer Forum
1

Hi

I have create a SSRS report using PreProcess Class , in this report i am using 2 tables (1st header , 2nd Lines),

Tables are Regular and CreateTransactionID = ‘YES’ . After running report , record does not display and then i checked line tables CreateTransactionID field is 0 Zero, Please help , why its coming Zero .

Thanks in Advance !!!

2

Do you have any reason for not using SRSReportDataProviderPreProcessTempDB?

3

not a specific reason , but may you tell me regular table will be getting problem for that

4

My point is that if you use the recommended solution, you won’t have this problem, so I wonder why you would use a not-so-recommended solution especially if it doesn’t work for you? Why would you invest your time into it (and ask me to do the same)?

5

Actually I saw std report “Sales invoice” which is used Preprocess class(SalesInvoiceDp) and Regular table, that is the reason i used regular table.

6

That’s the older solution, now you can use TempDB tables and avoid all these problems with transaction IDs, data cleanup etc.

7

Thanks Marin