Formula field function

6 posts, 0 answers
  1. Molivia Sa
    Molivia Sa avatar
    9 posts
    Member since:
    Jan 2010

    Posted 31 Jan 2010 Link to this post

    Dear telerik team,

    I was wondering if in telerik reporting they have a function field or formula field that can be re use in the texbox for many times. its like the crystal report formula fields.

    Thank you
  2. Steve
    Admin
    Steve avatar
    10940 posts

    Posted 01 Feb 2010 Link to this post

    Hello Molivia Sa,

    We do not have specific "formula fields" available like in Crystal. However you can handle your field value calculation in an user function in your favorite programming language. Then you can use the function in the report designer like so: = MyUserFunction(Fields.MyField).

    Kind regards,
    Steve
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  3. devesh
    devesh avatar
    2 posts
    Member since:
    Mar 2011

    Posted 02 Jun 2011 Link to this post

    How can we pass multiple values using c# for    in    operator of filters of Telerik Reports?
    Example :

    =Fields.CustomerId    in    (1, 6, 7, 88, 22)

    Thanks
  4. Steve
    Admin
    Steve avatar
    10940 posts

    Posted 03 Jun 2011 Link to this post

    Hello devesh,

    We've answered your inquiry in the other forum thread you have opened, please review our answer there for more information.

    All the best,
    Steve
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  5. siegfried
    siegfried avatar
    3 posts
    Member since:
    Oct 2018

    Posted 02 Aug in reply to Steve Link to this post

    Just a remark if I can : when you notice the answer is "somewhere else", could you remind the link, would be very useful for other users, as I myself look this information, and turning around for already an hour...

    Thanks
  6. Silviya
    Admin
    Silviya avatar
    414 posts

    Posted 07 Aug Link to this post

    Hi Siegfried,

    I agree. Please let me post the answer from my colleague in the other post here as well:

    "Currently our expressions don't support the required syntax. However, you can achieve the same result with a simple user function:

    public static object[] SplitArray(string values)
    {
        return values.Split(',');
    }

    Then you can use the above user function in the reports expressions as shown in the following sample:

    Expression: =Fields.CustomerID 
    Operator: In
    Value: =SplitArray("1, 6, 7, 88, 22")

    "

    Regards, Silviya
    Progress Telerik

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top