How to skip records in Reports.

vj_iway

Hi all,
I am building a report in which i have to print the debit balances of customers and skip all those customers which have credit balances.With this also i am giving a page break after each customer change.So please help.


Regards
Vj_iway

ajerome31

hi,

you can use fetch method in this init method of the report.

ex:

while select * from custtable where custable.currencycode == 'EUR'
{
element.send(custtable); // your body section must be linked with the custtable table.
}

regards

kranthi

Hi,

U can use a programmable section in fetch method which can be executed if the amount is greater than zero, that mean debit balance

eg:if(amount > 0)
element.execute(1);

for page break u can use
element.newpage();
for that u just compare the present customer with the old customer.
if the customer are not same u can use the above code.

eg. if(customer != custtable.accountnum)
{
customer = custtable.accountnum;
element.newpage();
}