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
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 ...How to Investigate or Debug Report Desk Problem by Using Registry Keys
Release Date: 01/25/2025 Version: 8.6 & Up Report Desk is based on the PSQL relational engine. It sends a SQL statement to PSQL engine to retrieve data. Sometimes, you don't get the result back that you expected, so what next? For example, when you ...How to Investigate or Debug Report Desk Problem by Using SQL Statement
Released Date: 1/25/2025 Version: 8.6 & Higher Report Desk is based on the PSQL relational engine. It sends a SQL statement to the PSQL engine to retrieve data. Sometimes, you don't get the result back as you expected, so what next? For example, when ...CPSLSDSK Customer Order Processing Sales Desk
Sales Desk Application Overview Sales Desk is designed for companies who need versatile order entry functions and improved customer service. It is designed to be used by salespersons, order entry personnel and telemarketers. Sales Desk is extremely ...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. ...