Notifications
Announcements
No record found.
Hi
What is the difference between Temporary table and Integer DataItem in Reports.
Thanks
*This post is locked for comments
Temporary Table is a table which filled by you, You should gather some data from other tables.
Integer is using general for Looping I suggest you to look some standart reports.
I add only that Temporary tables are created in memory as empty tables and the object is disposed at the end of your usage.
Hi jsshivalik,
1. A temporary table is a temporary variable that holds a table. A temporary table is used as a buffer for table data in your C/AL programs. You can use a temporary table just like you use a database table. The differences between a temporary table and a database table are as follows:
- A temporary table is not stored in the database, but is only held in memory until the table is closed.
- The write transaction principle that applies to a database table does not apply to a temporary table.
Advantage of a Temporary Table:
- The advantage of using a temporary table is that all the interaction with a temporary table occurs on the client. This reduces the load on both the network and the server.
- When you want to perform many operations on the data in a specific table in the database, you can load the data into a temporary table when you modify it. Loading the data into a temporary table speeds up the process because all the operations are performed locally on the client.
2. The Integer virtual table includes integers in the range –1,000,000,000 to 1,000,000,000. The Integer virtual table contains only one field. By applying a filter to the Integer virtual table, you can easily get a subset or range of numbers that can be used to control looping in reports.
Read this:
www.dynamics101.com/temporary-datasets-reports-dynamics-nav-2013-r2
It's not about the difference, it's about when to use each of them. Temp is for data storage and Integer DataItem is for looping and counting.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
