Report Desk: Variables in Title and Column Headings

Report Desk: Variables in Title and Column Headings

Release Date: TBA
Version: 8.6

Elliott allows for certain customization of the product.  For example, your company may use the Item Size file to specify Colors instead of something else.  In order to make this work well, you may need to insert a variable, based on a pre-defined PSQL User Defined Function, into the report title and/or report column titles.  To do this requires the following steps:

In the Template for User Defined Report, create a formula that contains a PSQL function like GETSTYLEGROUPLIT(), in the following:



Save the template and return to the User Defined Report Designer screen.  Now we can use this formula in the title of the report, if desired, and in column headings also:  Note: You cannot drag a formula (or any other item) to the Column Heading area -- drag-and-drop only works in the Column column.  You must type the formula name in the cell below Column Heading.


When the report is run, the variable [SizeLit] will be replaced by the value of the formula specific in the template.  In this case, Color.



JEG


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

    • Report Desk: Missing Column Title

      Release Date: 1/8/2023 Elliott Versions: 8.6 and Later How to Fix a Missing Column Title Occasionally, during custom report development, you may see something like the following when you first run the report: In this case, the column title ...

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

    • Data Structures for Report Desk Defaults and Enforcements

      Release Date: 9/19/2022 Version 8.6 and Higher In Report Desk, users can save their input values, as well as output option in templates and re-use them in the future. On the first Report Desk screen, the system prompts you to input the selection of ...