Report with temp tables

MortenSteengaard
MortenSteengaard Member Posts: 144
in NAV Three Tier
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

Answers

  • lubost
    lubost Member Posts: 633
    <record>.ISTEMPORARY property probably can help you.
  • MortenSteengaard
    MortenSteengaard Member Posts: 144
    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

Categories