Search This Blog

Friday, February 14, 2014

How To Use Temporary Tables In Reports

Step 1: Take a Report and Add a Table. 
Step 2: Make sure that Table Properties set as "Temporary: YES"
(OR) In Report init method write this code 

           Tmtab.setTmp();



Step 3: Apply this code in code in the report level Fetch Method :



public boolean fetch()

{
str acc;

boolean ret;

// ret = super();
while select custTable
{
Tmtab_1.CustAccount = custTable.AccountNum;
Tmtab_1.doInsert();
this.send(Tmtab_1);
}
return true;
}



No comments:

Post a Comment