This is a migrated thread and some comments may be shown as answers.

Formula field function

5 Answers 188 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Molivia Sa
Top achievements
Rank 1
Molivia Sa asked on 31 Jan 2010, 10:29 PM
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

5 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 01 Feb 2010, 12:31 PM
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.
0
devesh
Top achievements
Rank 1
answered on 02 Jun 2011, 07:38 PM
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
0
Steve
Telerik team
answered on 03 Jun 2011, 01:22 PM
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
0
siegfried
Top achievements
Rank 1
answered on 02 Aug 2019, 12:18 PM
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
0
Silviya
Telerik team
answered on 07 Aug 2019, 07:10 AM

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
Tags
General Discussions
Asked by
Molivia Sa
Top achievements
Rank 1
Answers by
Steve
Telerik team
devesh
Top achievements
Rank 1
siegfried
Top achievements
Rank 1
Silviya
Telerik team
Share this question
or