How to creat the temporary table to store the data for reporting

[Jonathan]

Dear all

How can I create the temporary table and extract the appropriate data into
this table and then show those information on the report.

Thanks for your kindly help

Jonathan

[Roman Rous]

See standard report 202 Sales Document - Test.
There is global record VATAmountLine declared as Temporary (see its
properties).
It is calculated on dataitem CopyLoop and printed on dataitem VATCounter.

RoRo

"Jonathan" <ah-...@hkem.com> píąe v diskusním příspěvku
news:%23xhwABA...@TK2MSFTNGP09.phx.gbl...

[David]

Hi Jonathan

Create a record name to point at a table, in C/AL Globals:

Name DataType Subtype
CustTmpRec Record Customer

View the properties of CustTmpRec and in the Temporary
property, choose Yes.

The CustTmpRec has all of the accesses that are assigned
to the Customer table apart from CustTmpRec will start
off empty and no Records will be retained, on exiting the
report.

Read and assign the Customer records...

IF CustRec.FIND ('-') THEN
REPEAT
CustTmpRec.COPY (CustRec);
CustTmpRec.INSERT;
UNTIL CustRec.NEXT = 0;

or the equivalent read as on a report.

Once all the temporary records that you require in your
report, add a new dataitem to the same report, called
Integer and add the following code...

OnPreDataItem()
SETRANGE (Number, 1, CustTmpRec.COUNT);

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

On your report sections, you display the details of the
CustTmpRec.

Hope this helps!

Good luck

>.
>

[Jonathan]

Really thanks for your kindly help!!

"Jonathan" <ah-...@hkem.com> 在郵件
news:%23xhwABA...@TK2MSFTNGP09.phx.gbl 中撰寫...