web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Why we need to set &qu...

Microsoft Dynamics AX (Archived)

Why we need to set "Create Transaction Id set to Yes in table for table type "Regular table" in SSRS report

(0) Share

Report

Report

Posted on by @rp@n

28

Dear All,

When we are creating SSRS report with "Regular Table" then in TempTable > properties

we set

1. Table Type : Regular and
Create Transaction Id = YES.

2. We need to create 2 methods for Temp Table
get() and

set()

3. Process Report() :

TempTable.setConnection(this.ParmUserConnection);

Can you please let me know why we need to set "Create Transaction Id set to Yes.

What it's does ?

Please give me more shed on this.

Thanks!

Arpan

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Michel Chacaliaza 104 on at

Like (0)

Report

RE: Why we need to set "Create Transaction Id set to Yes in table for table type "Regular table" in SSRS report

I made the indicated adjustment and it did not work that I can try otherwise. Thanks!

Was this reply helpful? Yes No
@rp@n 28 on at

Like (0)

Report

RE: Why we need to set "Create Transaction Id set to Yes in table for table type "Regular table" in SSRS report

Thanks Sukrut

Was this reply helpful? Yes No
Verified answer

Sukrut Parab 71,699 Moderator on at

Like (0)

Report

RE: Why we need to set "Create Transaction Id set to Yes in table for table type "Regular table" in SSRS report

HI Arpan ,

When you want to use preprocessing logic in report you have to use following three properties

On the table that is returned as a dataset to you have to make following changes

Created by - Yes

CreatedTransactionId - Yes

TableType - Regular

Refer blow MSDN blog to understand why preprocessing helps to improve time out issues.

blogs.msdn.microsoft.com/.../why-does-converting-a-report-to-pre-processing-help-to-resolve-timeout-issues

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Responsible AI policies for the Community

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Syed Haris Shah 9

#2

Mea_ 4

#3

Martin Dráb 2 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans