C# Crystal Report Problem
Hi
I am working on C# windows application that uses crystal reports. I have a formula field. This works fine when I preview in crystal, but gives an error message when i try it thru my application.
I am using crystal report XI. following is the code for formula field:
If InStr({q_PortfolioPerfStatsDetails_Base;1.TestDesc ription2},"Expected Asset Liquidation Months",1) =1 Then
Formula = cstr(ceiling({q_PortfolioPerfStatsDetails_Base;1.P erfValue2}))
elseIf IsNull({q_PortfolioPerfStatsDetails_Base;1.PerfVal ue2}) Then
formula = "N/A"
Else
formula = CStr({q_PortfolioPerfStatsDetails_Base;1.PerfValue 2}, _
IIf({q_PortfolioPerfStatsDetails_Base;1.DisplayTes tAsPct2} = 1,2,0)) + _
IIf({q_PortfolioPerfStatsDetails_Base;1.DisplayTes tAsPct2} = 1,"%","")
End If
Can anybody help me...
Thanks and Regards
Abhijeet
|