Is it possible to use IF statement, SWITCH CASE Statement, while loop etc. in the CALCULATED FIELD OF Report writer.
suriakumar
Suriakumar,
There are two types of calculated fields:
- Formula - Contains a PxPlus expression that will be evaluated when the report is being generated. You can then define a Filter that will use the calculated field in its condition. For example, you could create a calculated field TOTALCOST that calculates COST+TAXES which can then be displayed on your report. Or you could define a Filter to only display the records where, for example, TOTALCOST > 1000. Or you could use it to set up different Cell or Line displays.
- Translation - This allows you to specify several conditions which will determine what is displayed on the report. For example, you could create a translation called MyMessage where the condition BALANCE>0 returns "Balance Due" and the Default returns "Paid".
For more information on Calculated Fields, see:
https://manual.pvxplus.com/page/Report%20Writer/Designing%20a%20Report/Defining%20the%20Data/Calculated%20Fields.htm
Or check out the new training manual at:
https://home.pvxplus.com/files/7068/Introduction_to_PxPlus_-_A_Hands-On_Training_Guide_for_Developers.pdf
and search for 'calculated fields', or go to page 218.