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

    • Report Desk: User-Defined Formulas

      Release Date: 1/16/2024 Versions: Elliott V8.6 and Above Background Prior to this release, users had the ability to create a user-defined formula by dragging the [New Formula] node on the TreeView in the report designer to a line on the report. That ...

    • 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 ...

    • Report Desk: Global Variables, Parameters and Embedded Functions

      Release Date: TBA Version 8.6 Using Global Variables Sometimes it is necessary to access the fields in Elliott's control files, like NSCTLFIL and IMCTLFIL, in order to produce the desired report. For example, in reports that have item cost data, you ...

    • Upgrading to New Telerik Components

      Release Date: 10/24/2022 Versions: Elliott 8.6 and Higher How to Upgrade Visual Studio Projects that Use Telerik Components Run Progress Control Panel on a Machine that has a Telerik License Download the latest WinForms and Reporting components. ...