Report Desk: Telerik Functions

Report Desk: Telerik Functions

Release Date: 4/28/23
Elliott V8.6

Telerik Functions in Report Desk

In addition to the Aggregate functions that are automatically mapped to Telerik functions in Group Headers and Footers and Report Footers, you may also use built-in Telerik functions in the Designer Template.  In the example below, a simple Aggregate function could not provide the value desired -- namely computing a value based on other aggregate values-- so a Telerik function was used.

The function inside the red box below is an example of a Telerik function that is used in Group Footers and Report Footers in the UDR Promotion History Report.  Note that it begins with the "=" character.  That tells Report Desk that this function is a Telerik function, not a SQL function.  This Gross Profit Percent function, GPPct in the Name column below, does a Sum() on the Extended Price minus the Extended Cost, then divides that amount by the sum of the Extended Cost, then mulltiplies it by 100 to display it as a percentage.



Note: Notice the first portion of the formula
= Sum(Fields.ExtPrice) = 0 ? 0 : Sum(Fields.ExtPrice - Fields.ExtCost) * 100 / Sum(Fields.ExtPrice)

This acts as an if or a case statement. If Sum(Fields.ExtPrice) = 0 then the function will return zero. Otherwise, the function will perform the calculation.

This function was then added to the Report Footer of the report:


Note that a Telerik function must not have an Aggregate function also applied.  Notice the way the Aggregate: field is left blank:


Additional Documentation

For more information on Telerik functions, visit the following link:


JEG
EL850RD, SYRPTUDR



    • Related Articles

    • Installing Telerik Components on a Development Computer

      Release date: 5/5/2002 Version: Elliott V8.6 and Higher This article explains how to install licensed Telerik components on a development machine where they are not currently installed: Log into the development machine. Bring up the email you ...

    • How to Avoid Divide by Zero Error in Report Desk

      When designing a custom report, you can also define a formula like "MarginPct." It has a value taken from a complex SQL column definition using numeric fields to compute the margin percent. Normally, you will test the formula in the PSQL Control ...

    • New User-Defined Functions in Elliott DDF

      Release Date: 12/6/17 Modified Date: 07/08/2024 Version: 8.5 & up In the future DDF (target to be released with Elliott 8.5,), we will add the following four user-defined functions: ELIDATE2SQL SQLDATE2ELI ELITIME2SQL SQLTIME2ELI For example, you can ...

    • Developing a New Elliott V8.6 Report Desk User Defined Report (UDR)

      'Release Date: 6/20/2018 Version: 8.6 & Up This document is written for licensed Elliott Software developers. It is not relevant for regular Elliott users. Overview With proper licensing, Elliott developers can follow these three steps to create a ...

    • Feature: Searches for Report Desk Input Parameters

      Released: 3/4/2024 Verson: Elliott v8.6 and higher Overview Until now, Report Desk users did not have the ability to search the database for a specific value of an input parameter. With this release, the ability to search for database values for an ...