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

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

    • 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: 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: Column Formatting

      Release Date: 4/28/23 Elliott Version 8.6 Changing Column Format When you are in the Report Desk designer and you drag a column one of the Line grids, a default column format will appear. You may change the format of the column to another type by ...

    • Report Desk: Multiple Lines

      Release Date: 4/28/23 Version: 8.6 Overview In many cases, there will be more information needed for a body line (or group header, footer, etc.) than can fit within a single line. Report Desk provides the ability to specify multiple lines in those ...