Report Property: TransactionType

jessielai

Dear Navision Gurus,

Could someone clarify what is the purpose of

TransactionType

in report property? I do not understand the explanation found in online help.

Thank you. [-o<

Iqbal_Febriano

It is related to how your report show the data. For example, you 're processing a report, at the same time someone is doing a posting routine that affect the table used for the report.
Wheter the report will show the data before the table is updated or it waits until the table updated and show the updated data, will depend on the TransactionType you choose.

CMIIW

Kowa

If the database runs on the native server, you can ignore this property.
It is relevant only when SQL Server is used and determines how changes in the database data are handled while a transaction, where this data will be used, is uncommitted.
Depending on this setting, the report can show up different values.

jessielai

Thank you for your replies

What is the result if I use TransactionType = Report? According to the manual, system will auto map Snapshot for Navision server and Browse for SQL server. With reference to Kowa's reply, TransactionType is only for SQL server, am I right?

I try to understand better of the above feature so that I can apply to some of the reports that I've developed.