[Solved] DateTime Functions in Telerik Reports

[Kaushal Shah]

Hi,

In telerik Report , can i calculate age from DOB that i get for each record in my query.

Is there any datetime functions or formula fields available like in crystal reports for doing above thing?

Please reply me as soon as possible.

Thanks in advance.

[Steve]

Hi Kaushal Shah,

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 language. Then you can use the function in the report designer like so: = MyUserFunction(Fields.MyField)

Best wishes,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Kaushal Shah]

Thank you very much Telerik Team for providing me solution for formula fields

[Elliot]

Thanks for the clarification.
Even though Telerik Reports does not support formula fields like Crystal Reports, using a custom user function is a practical and flexible solution.
Calling the function directly from the report designer keeps the report clean and allows full control over date calculations such as age from DOB.
This answer clearly points developers in the right direction. Much appreciated.