You can also use Select Case as follows
Open the Report Goto Insert Field Object --> Right Click on Formula Field --> New
Give a name to Formula..then give the formula as
Select {sales_transaction.transaction_type}
Case "sr":
10.00
Case "si":
5.50
Case...
From the report Click on Database --> Visual Link Expert ..Then you will be able to see the tables added in the report..You can click on the field name in the first table drag it to the field name in the other table you want to join.This is how you cna join..There is an option for automatic...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.