How could i formulla field set in Telerik Reporting

Thread is closed for posting
4 posts, 0 answers
  1. Tamim
    Tamim avatar
    64 posts
    Member since:
    May 2011

    Posted 06 Nov 2012 Link to this post

    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.
  2. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 06 Nov 2012 Link to this post

    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
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Tamim
    Tamim avatar
    64 posts
    Member since:
    May 2011

    Posted 06 Nov 2012 Link to this post

    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.
  5. Tamim
    Tamim avatar
    64 posts
    Member since:
    May 2011

    Posted 06 Nov 2012 Link to this post

    Thanks again.

    Solve the problem

    Thanks,
    Ansari.
Back to Top