I am using ASPRunner 7.0 Build 9948, Windows 7 OS, Sql Server 2008 R2. I have read the "Calculations" section of the manual and I still have a need after that.
I have a need to allow a user to enter a number into a table field in the add record. A second field in the same table will display the calculation result that uses the number in field A and places it into field B. The calculation is like:
2*10=20
The 2 was entered in field A and I need the system to multiply it by 20 and automatically enter it into field B.
I have been able to use the SQL Query to make this happen and it shows up in the list program but not in Web Reports. Does anyone know how to make the calculation result show up in Web Reports?
Thanks for your assistance,
Joe