How to change textbox text dynamically in Crystal Reports using a formula

Question

I just trying to change textbox text dynamically in Crystal Reports using a formula but I did not find where should I put the formula?

Shalini Khare

Answer 1

Step 1- Insert two Text box (At same place)
Step 2- Write Pass in first textbox and fail to another
Step 3- Right Click On First textbox
Step 4- Select format object
Step 5 Check On Suppress checkbox
Step 6 Open Suppress formula editor and put your formula like

if {Table.TotalMarks}> 400 then
true
else false

Step 7 Save and close
Step 8-Apply same for second textbox (change formula)
Step 9 Now execute your program

Answer 2

Step 1-Insert textbox
Step 2- On crystal report ,Open Formula field section. Right click that and add new formula.
Step 3- Give name of Your formula and click OK
Step 4- Write down formula to change textbox text dynamically Like
If{Table.TotalMarks}>400 then "Pass"
Else "Fail"
Step 5- Save and Close
Step 6- Drag this formula from Formula Field and drop it into textbox
Step 7- Now execute your program

Answer 3

Instead of textbox write a formula and place the formula in the textbox place.

Answer 4

On crystal report , you can find FormulaFeild section. Right click that and add new formula and apply your logic

EDIT