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

30

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)

Verified answer

Sukrut Parab 71,710 Moderator on at

Like (0)

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
@rp@n 30 on at

Like (0)

Report

Thanks Sukrut

Was this reply helpful? Yes No
Michel Chacaliaza 104 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

#1

Martin Dráb 4 Most Valuable Professional

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans