Event Handler not executing in SSRS report in D365FO

(1) Share

Report

Posted on by CU09091357-0

501

I did a customization on a report by adding a field, and I did a event handler class that should execute on inserting in the tmp table, so I can fill this field that I added.

Unfortunately, even the field is empty because the event handler code is not executing, anyone knows why?

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (7)

Answers (1)

Layan Jwei 8,112 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Is this a report based on query or RDP?

And can you put the break point on line 6 instead please? And try to debug again

Was this reply helpful? Yes No
CU09091357-0 501 on at

Like (0)

Report

Layan Jwei thank you for your response.

It's an RDP based report.

Probably the event handler (onInserting) is not executing because the main DP class is inserting into tmp table through insert_recordset method.

Any idea how can we trigger this event?

Was this reply helpful? Yes No
Layan Jwei 8,112 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

What's the name of the report you did a customization for?

Yes if it's an RDP, then inserting to the tmp table needs to be handled in the DP class.

Was this reply helpful? Yes No
Martin Dráb 237,959 Most Valuable Professional on at

Like (1)

Report

By the way, there is a bug in your code. You iterate BankAccountTrans records, but you keep overwriting the same value. You effectively take the value from the last record and loading all the previous ones is just a waste of resources.

If you really want the last one, remove the while loop and use just a normal select statement with firstOnly keyword. Also, add an order by clause, because which record is the last depends on sorting. Your current code leaves the decision on the DB server.

Or maybe you wanted to take all records into account but you didn't add the necessary logic.

Was this reply helpful? Yes No
CU09091357-0 501 on at

Like (0)

Report

Layan Jwei it's the bankAccountStatement report

Was this reply helpful? Yes No
CU09091357-0 501 on at

Like (0)

Report

Martin Dráb I want to fill each record by its right description column value.

Was this reply helpful? Yes No
Verified answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Try to add your code in processReport method of your report's RDP class using COC extension or use the

post handler event method of processReport(), as in the following link:
https://community.dynamics.com/blogs/post/?postid=19c6056b-956f-4325-bf2a-25b9c0ea9e12

Thanks,
Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No