Creat a temporary table

Nuno_Pereira

How i can create in navision a temporary table and print a report with that temporary table?

HalMdy

In the report, create a global variable for the table. In the properties of the variable, mark it as Temporaly.

At the beginning of the report, you have to code the fill of the table ...

RobertJ

Create a record variable based on the Table that you want to use. I'll call mine TEMPMyTable. In the Properties of this variable set Temporary to Yes.

You will then need to add code to populate your temporary table.

Create an Integer DataItem.

In the OnPreDataItem Trigger insert code as similar to this:

SETRANGE(Number,1,TEMPMyTable.COUNT);

In the OnAfterGetRecord Trigger insert code as similar to this:

IF Number = 1 THEN
TEMPMyTable.FIND('-')
ELSE
TEMPMyTable.NEXT;

This will allow your Integer DataItem to loop through your temporary table as a non-temporary DataItem would.

Any controls that are placed in the Sections will have to point to your temporary table variable.

kriki

http://www.mibuso.com/forum/viewtopic.php?t=6773