Integer table position in report?

mdsr
mdsr Member Posts: 163
in NAV Three Tier
in report how position of integer table affects report
in sales invoice report 206 we add integer table after sales invoice header why we not put it on the top of data set and what would be it's effect
thank you

Answers

  • SanderDk
    SanderDk Member Posts: 507
    hi @mdsr,
    A integer table is offen use i report (like 206) because they use temporary table, and on previous version of the report element it was not possible to use a temporary table.
    So a lot of legacy here :smile:
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.
  • Sachin_
    Sachin_ Member Posts: 67
    Hello @mdsr ,

    The "Integer" DataItems are a kind of FOR-NEXT construct where you know upfront the number of iterations in the loop, but you do not want to/or cannot link this directly to a physical table in your database.

    Example:

    You want to generate three copies of your invoice. So you implement a dataItem "CopyLoop" based on Integer and set a filter to Number 1..3.

    This forces the system to run through the more indented dataitems the number of times you defined in the "CopyLoop" and therefore create 3 copies.

Categories