Utility of the Integer DataItem in Reports

write2sourav

Hi,
What is the utility of the "Integer" DataItem in Navision. It is used in many base reports. Plz help

kriki

In dataports, you need to use a table, not a temptable to loop for printing.
Problem can be that you DON'T have a table, but only a temptable or you know you have to loop the dataitem 4 times. In these cases you need to use anywat a 'real' table. The virtual table "Integer" can be used for this. With this you can loop the dataitem 4 times or so many times as you have records in your temptable that you want to print.

Captain_DX4

One good example for newbies would be Report 10074 "Sales Invoice" (could be numbered differently in your version if you aren't on the North American version).

First, the detail of the Integer table: It is defined with records with a single column (Number), and the field is pre-populated by the system with integers (positive and negative) up to the largest supported integer in Navision.

In the report, we see a dataitem described as "PageLoop". It uses the Integer table as a dataitem because we want to give the user the option to print the number of copies they require without having to hit Print several times to get copies. The Integer record will get filtered based on the number of times the user requests the invoice to print.

So by filtering on the Number field dynamically during runtime, we can use the table to give us multiple invoice copies easily.

kriki

Captain DX4 wrote:

One good example for newbies would be Report 10074 "Sales Invoice" (could be numbered differently in your version if you aren't on the North American version).

In W1 it is report 206:"Sales - Invoice".

Miklos_Hollender

In simpler words, most DataItems implement a "For Each" loop, while the Integer table implements a "For" loop.

nikeman77

Miklos Hollender wrote:

In simpler words, most DataItems implement a "For Each" loop, while the Integer table implements a "For" loop.

Hi Miklos,

Appreciate that, but as what Captain DX4 mention :
First, the detail of the Integer table: It is defined with records with a single column (Number), and the field is
pre-populated by the system with integers (positive and negative) up to the largest supported integer in Navision.
Who(Navision/User?) declare the column field: Number? Can it be reName/ Deleted/ Add Field/ Modify FieldName etc?

Dont understand the For Loop concept, we need the original data item will do if its the case and do filtering programmatically.

Belias

Who(Navision/User?) declare the column field: Number? Can it be reName/ Deleted/ Add Field/ Modify FieldName etc?

Integer table is a virtual table:
http://msdn.microsoft.com/en-us/library/dd338858.aspx

we need the original data item will do if its the case and do filtering programmatically.

:-k I don't understand...
btw,
-look at the report 206 as suggested for a sample about: use integer to do "for loops."
-look at the how to's section: temporary tables in report (or a title similar to this), to see a sample about: how integer table can be used to print temporary tables.