Integer Table

roshandilruk
roshandilruk Member Posts: 51
edited 2005-11-23 in Navision Attain
Hii,

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

Roshan

Comments

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    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?
    Marije Brummel | Freelance Business Central Specialist
  • roshandilruk
    roshandilruk Member Posts: 51
    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
    sgg Member Posts: 109
    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)
    Sunday, Godwin G
  • roshandilruk
    roshandilruk Member Posts: 51
    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
    kriki Member, Moderator Posts: 9,121
    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".
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories