Unable to use datasource.column inside formula/variables.

[Arunkumar S]

I have created a variable vApplicationType In which i have the following code

iif (Application.fkPickFromListApplicationType.TOSTRING().Trim().LENGTH()=0,"",Application.PickFromListValue)

It Does not display any data but, when i use the field directly, it displays the actual value. And also i found that inside iif (true or false part) if i use any of the datasource.field it is not displaying any data, if i use any variable or hardcode some values it is coming up fine. is there any other way to do this or i'm not using it in the right way?.

This report has 140 such formula columns, i have to display different column and its values that is
iif(aplication.functionNm="xyz",application.column1,application.column2)

Nested iif is possible, i have 2-3 such cases which needs nested iifs?

Note: In the report setup i have selected the source code as "VB"

Thanks in advance.

[Edward]

Please provide us with more detail about Application.PickFromListValue and application.column1. How do you get these values? Also please see the following post:

http://forum.stimulsoft.com/Default.aspx?g=posts&t=719

Thank you.