Crystal Reports vs BaaN-ledger Debet/Credit

[iemand]

For our Budget/Actuals report want to use Crystal Reports, only we have the following problem: In BaaNs Ledger we can only get the absolute numbers (only positive not negative). BaaN looks at other record (D/C) whether or not the record has to be subtracted. This record is a Boolean. We cannot find a formula with which we can tell Crystal Reports that a record with the value 1 (=Credit) has to be subtracted from the Running Total.

Please can any tell how we can tell C.R. this?

With many thanks in advance.

Henk

 

[dgillz]

Create a formula field:

If {BannDCField}="C" then {BaanAmountField}*-1 else {BannAmountField}

Then base your running total on this formula field rather than the database field. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[iemand]

dgillz,

Unfortunately this does not work. Since {BaanDCField} is a Boolean-field (true/false) C.R. reacts with the following error: "The result of selection must be a boolean".

I hope you have another solution to this problem.

With many thanks in advance.

Henk

 

[dgillz]

Create a formula like this then:

if {BaanDCField}=true then {BaanAmountField} else {BaanAmountField}*-1

Then use this formula in your running total field. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[iemand]

Dgillz,

Still the same answer from C.R.: "The result of selection must be a boolean".

Henk

 

[dgillz]

Where are you placing this formula? The only formula that must be a boolean is a record or group selection formula.

Click on insert, field object, formula field and create this formula. It WILL work. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[iemand]

Yes!!! It works!

Thanks!

Henk