Slow running SSRS reports

TappingFingersA colleague had clients complain of slow running SSRS reports… apparently they would time out after ten minutes. He found the post at http://sinedax.blogspot.com/2012/11/ssrs-report-ax-2012-operation-has-timed.html which provided the key. It talked about using userConnection to populate the data in a pre-process way. But he had trouble completing the circle.

In this case it was VendLedgerReconciliation… in VendLedgerReconciliationDP.processReport, he used parmUserConnection(), then he passed it to VendReport_LedgerReconciliation.processVendLedgerReconciliation. Once in that method, he did another setConnection using the passed parm.

And presto, the report works. Info about that is in the comments to the blog referenced, but I’m hoping this blog provides a clearer example.

Happy DAXing!

SSRSReportsTimeOut

Advertisements

About janeteblake

Dynamics AX developer
This entry was posted in AX2012, Dynamics AX. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s