Extension of a data provider class

(1) Share

Report

Posted on by Iulian Cordobin

8,201

Just wondering if anyone has faced this issue so far: you have to create an extension for a SSRS report's provider class and add a new table that will be send to the report using the SRSReportDataSetAttribute. All sound good and like it will work, until I get this error "An error occurred during report data sets execution".

The event viewer has only a "An exception occured during Ax Report Provider execution." message.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Martin Dráb 237,878 Most Valuable Professional on at

Like (0)

Report

When do you get the error? Did you try to debug it?

Was this reply helpful? Yes No
Iulian Cordobin 8,201 on at

Like (0)

Report

Hi Martin,

The error is displayed when the report (and by this I mean standard ssrs implementation code) is already running and passed the populate code in the DP. Debugging it shows that the augmented class is called properly in order to populate (method m1) the new table (a Regular table with a SetConnection on it); the call to m1 is done in the (base class) ProcessReport method via a delegate / handler subscribed. Looking at the table I see the record (with nolock).

I wonder, is anywhere in the SSRS execution when the processing engine fails to actually see the DataSetAttribute in the augmented class (reflection failing)?

Was this reply helpful? Yes No
Iulian Cordobin 8,201 on at

Like (0)

Report

I would have loved to see this work (it is quite a cool way to extend the DP classes / SSRS reports), but so far seems it either a bug, or maybe a not supported case? (OR maybe I'm missing something...).

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

Like (0)

Report

Is the method returning the data called successfully? It's called later than processReport().

The best thing would be sharing all details about the error, especially its type and call stack.

Was this reply helpful? Yes No
Gaetano Felice on at

Like (0)

Report

Hi Iulian,

did you found a solution for this issue?

I am facing the exact problem, but I don' t how to solve it.

I am extending the report data provider class fr the wmspickinglist report, I am adding a new dataset. The build goes ok, but when I run the report, I am having the error "An exception occured during Ax Report Provider execution."

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am having same issue. Trying to add new parameter to VendAgingReport. Extended DP class, Contract class. New field appears on a dialog box but at report execution time i am getting same error " An error occurred during report data sets execution"

Was this reply helpful? Yes No
Suggested answer

VinodKumarKJ 5 on at

Like (0)

Report

Hi,

The issue was with dataset referring to a table where some field was missing.

It is resolved.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi, Iulian Cordobin

Can you show me how you insert data to the new tmp table that you created?

Was this reply helpful? Yes No