SRSReportDataProviderPreProcess and SRSReportDataProviderPreProcessTempDB class in AX 2012 R3

(6) Share

Report

Posted on by CU05031448-0

1,323

Dear team,

As I learn and go through the concept of SSRS report. It extended classes like

SRSReportDataProviderBase. - Used for Regular table

SRSReportDataProviderPreProcess. - Used for In Memory table

SRSReportDataProviderPreProcessTempDB. - Used for TempDB table

*** Here I like to know how these two classes

SRSReportDataProviderPreProcess and SRSReportDataProviderPreProcessTempDB worked with SSRS report in real world.

I mean when we extended any of the classes, what will happened internally with SSRS report.

Kindly provide me an example of both for the clarity.

Thanks in advance.

Categories:

Microsoft Dynamics AX

I have the same question (0)

All responses (11)

Answers (4)

Verified answer

Martin Dráb 239,022 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

If generating the data takes too long, the report will time out. A workaround is generating the data before you even execute the report, which we call pre-processing.

SRSReportDataProviderBase (= no pre-processing) user InMemory temporary tables. SRSReportDataProviderPreProcess uses Regular tables and SRSReportDataProviderPreProcessTempDB TempDB tables.

2 people found this reply helpful.

Was this reply helpful? Yes No
CU05031448-0 1,323 on at

Like (0)

Report
Copy link

Link copied!

Thanks Martin for the clarity ..

So, if we need to do pre process the data before execution of the report , we can use either SRSReportDataProviderPreProcess or SRSReportDataProviderPreProcessTempDB.

What about the TempDB concept here? How it's worked with the report.

Kindky advise pls

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,022 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

TempDB table are temporary tables stored in the database. The purpose here is obvious to store data prepared for a report.

Was this reply helpful? Yes No
CU05031448-0 1,323 on at

Like (0)

Report
Copy link

Link copied!

Yeah, obviously it stored the data. If I used TempDB for the SSRS report, is it work much faster compare to inMemory or Regular table?

Kindly advise pls.

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

Like (0)

Report
Copy link

Link copied!

No, it's not about making things faster. If you run the same logic with or without pre-processing, it's still the same logic and it'll take the same time.

Was this reply helpful? Yes No
CU05031448-0 1,323 on at

Like (0)

Report
Copy link

Link copied!

Then what is the advantages to use SRSReportPreProcessTempDB to use in SSRS report?

Kindly advise pls.

Thanks!

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,022 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Let me quote the first paragraph of the first reply:

If generating the data takes too long, the report will time out. A workaround is generating the data before you even execute the report, which we call pre-processing.

Was this reply helpful? Yes No
CU05031448-0 1,323 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

As said "workaround is generating the data before you even execute the report, which we call pre-processing."

Generating the data before...

Where is reporting server?

Kindky advise pls

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

Like (0)

Report
Copy link

Link copied!

I'm sorry, but I don't know what you mean by Where is reporting server?. You'll need to formulate your question in a better way.

Was this reply helpful? Yes No
CU05031448-0 1,323 on at

Like (0)

Report
Copy link

Link copied!

I mean to say...

Martin,

As said "workaround is generating the data before you even execute the report, which we call pre-processing."

So, here Generating the data before execute the report. Where it's generating the data?

Is it in reporting server?

Kindky advise pls

Was this reply helpful? Yes No