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

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

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

    • Report Desk: Documentation Roadmap

      Release Date: 4/28/23 Version: 8.6 Setup and Configuration The following articles explain initial setup and ongoing maintenance of Report Desk: Report Desk: Setup and Configuration : Initial installation and ongoing maintenance. Elliott V8.6 ...

    • Report Desk: Report Footer

      Release Date: 4/28/23 Version: 8.6 The purpose of report footers in User Defined Reports is to provide the ability to report aggregate information (sum, average, min, max, etc.) for the report. For example, in a Salesman list, a report footer can ...

    • Report Desk Tables

      Release Date: Same as V8.6 general release Modified Date: 05/10/2024 Version 8.6 Elliott Report Desk, initially released in Elliott v8.6, relies on a series of database tables that reside in the Root directory. Following is a list of the files and a ...