How to skip records in Reports.

vj_iway
vj_iway Member Posts: 47
edited 2009-09-25 in Dynamics AX
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

Comments

  • ajerome31
    ajerome31 Member Posts: 6
    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
    kranthi Member Posts: 72
    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();
    }
    Kranthi

Categories