Thanks. Let me clear out any confusion here. I am displaying both Dynamic1 and Dynamic1_Val. The following conditions are being calculated for each record retrived from DB. If Param_Dynamic1 = "IT_PM, then Dynamic1 = "IT Project Manager", Text Field1.text = "IT Project Manager" (Value of Dynamic1) If Dynamic1= "IT Project Manager", then Dynamic1_Val = Query Field {IT_PM}, Text Field2.text = IT PM Value from DB (Value of Dynamic1_Val) The problem is that, not a single text field value is being displayed on the report. To your point: I agree that calculation of Dynamic1_Val is wrong. I will rectify that. But why Dynamic1 variable value is not displayed on the report even.