I am using FastReport to create my reports right now, and i have an issue.
I have an one data attribute named "ProductMaster.ITEMBUYINGPRICE".
The output of this data is a 6 digit value showing the cost price. Let us say, for example its 205,450 .
However since this report needs to be printed . I need to encrypt the costs into an alphabetical value so only certain staffs who know the encryption would be able to know the cost . Therefore i need the report to automatically convert the data stored in ITEMBUYINGPRICE into a string value
My formula is as follows :
V = 1
G = 2
O = 3
B = 4
I = 5
N = 6
D = 7
R = 8
A = 9
M = 0
Therefore the cost above would read as "GMIBIM"
Could you guide me as to how/what function i should use to code this into the report?