Integer Table

roshandilruk

Hii,

Can somebody tell me how to use Integer Table and when it is supposed to be used.. plz

Roshan

Marije_Brummel

You can use it for countless senario's. The ones I can think of directly are the copy/page loops in reports (e.g. 206) and builing statistics forms like the Item stats.

More anyone?

roshandilruk

Mark Brummel wrote:

You can use it for countless senario's. The ones I can think of directly are the copy/page loops in reports (e.g. 206) and builing statistics forms like the Item stats.

More anyone?

Thanx Mark.

sgg

You could also use it in Reports or Routines in which you do not want to Attach Tables Directly as DataItems. In which Case, the Tables will be Declared as Variables.

e.g (Report 29 Export Acc. Sched. to Excel)

roshandilruk

sgg wrote:

You could also use it in Reports or Routines in which you do not want to Attach Tables Directly as DataItems. In which Case, the Tables will be Declared as Variables.

e.g (Report 29 Export Acc. Sched. to Excel)

Can u explain me in detai abt this???? plz....

kriki

sgg wrote:

You could also use it in Reports or Routines in which you do not want to Attach Tables Directly as DataItems. In which Case, the Tables will be Declared as Variables.

e.g (Report 29 Export Acc. Sched. to Excel)

sgg means that the integer table can be used in case you want to print information contained in a temptable. The dataitems must be based on real tables (or virtual tables like integer).
Some example of code for using a temptable is:

Integer - OnPreDataItem()
tmpMyTempTable.RESET;
SETRANGE(Number,1,tmpMyTempTable.COUNT); // so the integer-table runs from 1 to the number of records in the temptable

Integer - OnAfterGetRecord()
IF Number = 1 THEN
  tmpMyTempTable.FIND('-')
ELSE
  tmpMyTempTable.NEXT; // NEXT = 0 is not necessary because you loop as many times (see filter on Number) as there are records in the temptable

To print a field, in the SourceExpression of the field you put tmpMyTempTable."My Field".