HI,
I want to design crystal report, not with designer, but in code. I can do it for simple cases. But I want more. Suppose I have created an instance of crystal report named Report. My ADO command returns a recordset with three fields, say X, Y, Z. I can display values of these
fields with syntax like:
Set fldX = Report.RD.AddFieldObject("{ado.X}",530, 100)
here, RD is the name of detail section. I want to display the value of either X or Z as column value depending on the value of Y. Something like:

If (ado.Y=M) then ' the problem is here, with (ado.Y=M).
Set fldF = Report.RD.AddFieldObject("{ado.X}",530, 100)
Else
Set fldF = Report.RD.AddFieldObject("{ado.Z}",530, 100)
End If

In conclusion, the problem is to dynamically check the value of some field and use that value to control program flow. Any suggestion is appreciated.