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

All responses (8)

Answers (0)

Community Member on at

Like (0)

Report

RE: Extension of a data provider class

Hi, Iulian Cordobin

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

VinodKumarKJ 5 on at

Like (0)

Report

RE: Extension of a data provider class

Hi,

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

It is resolved.
Community Member on at

Like (0)

Report

RE: Extension of a data provider class

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"
Gaetano Felice on at

Like (0)

Report

RE: Extension of a data provider class

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."
Martin Dráb 234,669 Most Valuable Professional on at

Like (0)

Report

RE: Extension of a data provider class

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.
Iulian Cordobin 8,201 on at

Like (0)

Report

RE: Extension of a data provider class

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...).
Iulian Cordobin 8,201 on at

Like (0)

Report

RE: Extension of a data provider class

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)?
Martin Dráb 234,669 Most Valuable Professional on at

Like (0)

Report

RE: Extension of a data provider class

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