checkboxes and double sections

dyn45

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?

Savatage

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.

David_Singleton

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.