checkboxes and double sections

dyn45
dyn45 Member Posts: 67
edited 2009-06-12 in Navision Attain
ok guys, here is what i am dealing with...

i am working with a report and the situation is next. i made on a request form two checkboxes named "credit" and "debit". when i check "credit" i would like to see on the report only entries where i have Credit Amount values, also, when i check "debit" i would like to see only entries with Debit Amount.

I tried something with double sections, but did not make it.

could anyone help me on this?

Comments

  • Savatage
    Savatage Member Posts: 7,142
    do you have any setfilter code that you tried on the report that you can post?
    What's have you tried? are you using cust ledger entry, vendor ledger entry..which table?

    these check boxes are you allowing the checking of both at the same time as an option?
    if not you vcan use an option button instead.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • David_Singleton
    David_Singleton Member Posts: 5,479
    dyn45 wrote:
    ok guys, here is what i am dealing with...

    i am working with a report and the situation is next. i made on a request form two checkboxes named "credit" and "debit". when i check "credit" i would like to see on the report only entries where i have Credit Amount values, also, when i check "debit" i would like to see only entries with Debit Amount.

    I tried something with double sections, but did not make it.

    could anyone help me on this?

    Step one is to define what is a Debit and what is a credit. Most programmers just think that you can count a negative as a credit and a positive as a debit, but this is not correct. So step one is to have an option field on the source entry table that says Debit,Credit and populate that field correctly.
    David Singleton

Categories