How could i formulla field set in Telerik Reporting

[Tamim]

Hi,
how could i set formulla filed in datatype for exapmle the condition(if and else if)
see my screen shot.
Data type : Supler i want datatype : Supplier
Data type : Emp i want datatype : Employee

Advance Thanks,
Ansari.

[Steve]

Hello Ansari,

You can use the IIF Conditional Function to achieve the desired result e.g.:

= IIf(Fields.CompanyPosition = "Emp", "Employee", Fields.CompanyPosition)

If you need to make this check for various company positions, you could nest as many IIF functions as needed in the false part of the main function.

Greetings,
Steve
the Telerik team

[Tamim]

Thanks for ur reply steve

How to check these condition in Fields.datatype in single field
see my screen shot

=IIf(Fields.datatype = "Emp", "Employee", Fields.datatype)
=IIf(Fields.datatype = "Supler", "Supplier", Fields.datatype)
=IIf(Fields.datatype = "SubCon", "Sub Contractor", Fields.datatype)
=IIf(Fields.datatype = "Consul", "Consultant", Fields.datatype)
=IIf(Fields.datatype = "SerPro", "Service Provider", Fields.datatype)
=IIf(Fields.datatype = "Client", "Client", Fields.datatype)


Thanks
Ansari.

[Tamim]

Thanks again.

Solve the problem

Thanks,
Ansari.