Calculation fields(column) In crystal report

[Former Member]

Hi Experts

I have created a new report gainst A/R Invoice. Which contains DocNum, Docdate Card Name, DocTotal and Paidsum. Now I want derive balance and I want to put condtion formatting for those balance columns.

Can anyone help me How to calculate Doctotal-Paidsum to Balance column and to highlight the balance column which is more than sixty days amounts.

Waiting for ur replies.

By

Kalai

[Former Member]

you need to create a formula field to do this and then just drag and drop it into the report like any other column.

formula should be along these lines

{OINV.DocTotal}-{OINV.Paidsum}

as for the highlighting, just go to the designer, right click on the field you want to highlight and go to highlighting expert and follow the wizard from there to create a condition of when highlighting should occur. if your field is not available in the "Value Of" just build the field yourself as a Formula field and you will then be able to select that from the "Value Of" list.

hope it helps...

[Former Member]

Where can I find formula field. I tried in formula workshop with same calculation it says error "The result of selection formula must be a boolean".

What should i do now

[Former Member]

in "Field Explorer" (genreally on the right hand side) you should have Formula Fields listed under Database Fields. right click on Formula Fields and click on new.

it will load the Formula Workshop for creating a Formula Field. you probably got that error cause you were trying to build a Selection or a Formatting Formula (they are also done through Formula Workshop)

hope it helps...

Matthew

[Former Member]

Thanks alot for your reply It was late I have salved with help of my technical consultant.