How to empty tables when regular (ssrs 2008)

Finance and Operations/AX Developer Forum
1

Hi all,

does any one know how tables get empty after generation of an ssrs report when table type is regular?

Thank you

2

Hi,

If u set the table buffer as SetTmp initially, then table wil be regarded as temporary table (Or)

You can manually write a code to delete_from for that table.

Thanks :slight_smile:

3

Hello Vishal Tiwari,

Thank you for your answer, there is a third case; when you set connection on the table like :

youTableTmp.setConnection(this.parmUserConnection());

it get empty eventhough regluar, may be it uses somehow SetTmp() ? please tell me if i’am wrong.

Thank you so much

4

No I don’t think so that the above code is anywhere related to getting the regular table empty.

I suppose you are relating this to a RDP class which extends SrsReportDataProviderPreProcess. Here we take a Regular table wherein the data is getting filled and is further processed to make a report. In the DP class there is a statement:

youTableTmp.setConnection(this.parmUserConnection());

It sets the userconnection to use on table and is required to ensure that createdTransactionId of inserted record is different than default transaction.

For deleting purpose, there is table**.clear()** method which is called in the insertIntoTmpTable method of the class.

5

Basically clear method will be used to delete the buffer.

you can use it something like custtable.clear();

Only when you want you buffer to be empty.