Finance | Project Operations, Human Resources, ...

Regular table in SSRS report in D365FO

(0) Share

Report

Posted on by CU10121822-0

608

Hi team,

I do research and found some of the standard report used regular table in SSRS report. I mostly used in memory and temp db in my custom ssrs report.

I have a questions like

1. When we decide to go for regular table approach in ssrs report.

2. When we used regular table , then data will store on the table . If multiple developers worked on same report at a time then how data will fetch for respective users

3. Is there any property other than “table type =Reguler table” required.

4. Any explicitly code is required to maintain regular table in dp class in process report method.

Pls advise, thanks

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Abishek Jagadeesh 83 on at

Like (0)

Report
Copy link

Link copied!

Hi, regular table isn't really recommended anymore, use it only if you need data to persist beyond the report session, otherwise stick to TempDB. It's a shared table, so data gets filtered by a SessionId/UserId field, and you need an index on that field. You'll also have to manually insert with that tagging and delete old records yourself in processReport, since it's not auto-cleaned like TempDB. Thanks

Was this reply helpful? Yes No
CU10121822-0 608 on at

Like (0)

Report
Copy link

Link copied!

Hi Abhishek,
As mentioned,
Is sessionid / user id is automatically handled by the framework?
What index are required? Pls provide me an example.
Is only table type = regular table is enough?
Pls advise, thanks

Was this reply helpful? Yes No
Suggested answer

Anton Venter 20,917 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@CU10121822-0
How the data is isolated between users, is done with Created Transaction Id. The SalesInvoiceTmp has this property enabled. What does this do? When the data is created in a transaction (ttsbegin/ttscommit), it creates a unique ID for this field. All the data created inside the transaction, has this ID so that the data can be identified later. The SalesInvoiceDP keeps this ID in a variable and when the data is retrieved by the report, it uses this CreatedTransactionID to return only the data that was created by the report itself.

The data clean up for the Sales invoice report is done by a batch job. I assume this job gets added automatically to the batch by the system but I have not checked that and will be logical. But this is an assumption.

Was this reply helpful? Yes No
CU10121822-0 608 on at

Like (0)

Report
Copy link

Link copied!

Hi Anton, basically we extend controller class with “SysOperationServiceController” but in the above example the controller class is extended with “SysOperationServiceController”.
Why? Is the report executed on the batch?
Note - i don't have system access so I couldn't check it
Pls advise, thanks

Was this reply helpful? Yes No