SRSReportDataSetAttribute - Temp table

(1) Share

Report

Posted on by PhillyNJ

Hi,

I am populating a table to use in a report. After the report is created, what is the best way to clear the data from the table?

public WSTG_EndUserPurchOrder_TableTemp endUserTempTable;

[SRSReportDataSetAttribute(tableStr(WSTG_EndUserPurchOrder_TableTemp))]
public WSTG_EndUserPurchOrder_TableTemp getTempEndUserData()
{ 
   select endUserTempTable;           
   return endUserTempTable;
}

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Suggested answer

GirishS 27,843 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi PhillyNJ,

Normally SSRS report has table which is of type temp db.

No need to delete the record in the table if you set the table type as TempDB.

If still you want to delete the record in the table you can use delete_from in the processReport method before inserting records related to the report.

Thanks,

Girish S.

Was this reply helpful? Yes No
Arunraj Rajasekar 1,743 on at

Like (0)

Report
Copy link

Link copied!

Are you using a regular table to populate data?

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,218 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Just like @Girish said,

ALWAYS use temp table for SSRS report.

The table is emptied once the report is generated.

Was this reply helpful? Yes No
PhillyNJ 81 on at

Like (0)

Report
Copy link

Link copied!
If I set the table to TempDB, I get the following error:

Purchase inquiry (PO000000156-1) Fault was thrown by the service for request bc4b7621-01a7-49a4-b7ca-d99460ccdba9. Exception details: Type: Microsoft.Dynamics.Ax.Xpp.ErrorException Message: Table WSTG_EndUserPurchOrder_TableTemp used in report provider class should be a regular table.

Was this reply helpful? Yes No
GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

In DP class which standard class you extended?

Thanks,

Girish S.

Was this reply helpful? Yes No
PhillyNJ 81 on at

Like (0)

Report
Copy link

Link copied!

I am extending "PurchPurchaseOrderDP"

Was this reply helpful? Yes No
Verified answer

GirishS 27,843 Moderator on at

Like (1)

Report
Copy link

Link copied!

PurchPurchaseOrderDP extends SrsReportDataProviderPreProcess.

So if the dp class extends SrsReportDataProviderPreProcess the table used for that report must be regular table.

Refer to the below thread.

https://www.dynamicsuser.net/t/srsreportdataproviderpreprocess-is-used-to-work-with-regular-tables-with-the-included-properties-createdby-and-createtransactionid/62690

So you don't need to delete a record from the table. It will get deleted automatically when you re-run the report again.

Thanks,

Girish S.

Was this reply helpful? Yes No