1 (edited by anakin 2019-03-25 06:00:51)

Topic: Help with FastReport

Hi,

I need help in my FastReport on how to make the amounts in a column compute automatically (divided by 50) if the item on one of its rows matches the requirement (Registration).

from this:

Amount       Name         Description
100             John           Registration
200             Mary           Meals


to this:

Amount       Name         Description
2                 John           Registration
200             Mary           Meals



Please see attached.

Thanks!

Post's attachments

Attachment icon amount.PNG 14.45 kb, 169 downloads since 2019-03-25 

---may the force be with you!

Re: Help with FastReport

Hello.


Try to use calculated field for that

CASE WHEN description = 'REGISTRATION' THEN amount / 50 ELSE amount END
Dmitry.

3 (edited by anakin 2019-04-02 11:33:48)

Re: Help with FastReport

Hi Dimitry,

How will I do this in FastReport?
I don't know which button to click

---may the force be with you!

Re: Help with FastReport

In the database table, then you can add this calculated field to the fastreport.

Dmitry.