Report with temp tables

MortenSteengaard

Hi experts,

This is in Business Central cloud.

I have made a header table "H" and a table "L" with the lines in the header.

I have made a report that prints one H and the connected L records.

When the header table is posted, all fields on H and L are copied to two other tables, "Posted H" and "Posted L". And the H and L records are deleted.

Now, I would like to print the report from the posted records.

It is easy to recreate the H and L's in a temp table from the posted H and L's, but how do I make the report run on the temp records AND still run on the database records, when the report is called from a header, that is not posted yet?

I hope you can help.

Best regards,

Morten

lubost

<record>.ISTEMPORARY property probably can help you.

MortenSteengaard

Thanks lubost.
I think you are right, but there is still a long way to go.
I have come up with another solution, so I don't have to use temp tables.
Best regards,
Morten