Report Desk: Input Constants

Report Desk: Input Constants

Release Date: TBA
Version: 8.6

Background

Occasionally a report will need the user to enter a parameter input value that does not get used in a WHERE phrase, but may be used in a CASE statement in a function.  These input parameters are referred to as constants.  Here is an example.

Let's say you want the user to be able to enter a cutoff value constant which you will use to classify each detail row.  First, you need to create a function in the template that uses that constant:


In the above example, the input parameter called PctInClassA is represented by @@PARAM.PctInClassA@@ in the SQL function called SuggClass.  You can see that there are two such parameter input constants, PctInClassA and PctInClassB.

Now, you must drag a new constant to the Where Grid:


A default Column name is provided.  You should change the Prompt and Type column values as desired and then click on the info button to change the name to match the formula name and provide any other values:


After you save the design and run the report, the Parameter Input screen will look like this:


Further, press SQL to see how the constant value "80" replaces PARAM.PctInClassA@@ in the SQL SELECT statement:


Input Constants are available in this way to specify parameter values that are used in SQL functions defined in the report design template.

JEG


    • Related Articles

    • Report Desk: Optional File Input Parameter

      Release Date: TBA Elliott v8.6 This article describes how to allow the user to specify an input file of values instead of entering a comma-separated list of values for an input parameter with an "IN" or "NOT IN" Operator. Begin by setting the ...

    • Feature: Searches for Report Desk Input Parameters

      Released: 3/4/2024 Verson: Elliott v8.6 and higher Overview Until now, Report Desk users did not have the ability to search the database for a specific value of an input parameter. With this release, the ability to search for database values for an ...

    • 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: CheckBoxes

      Release Date: 4/28/23 Version 8.6 When to Use a CheckBox Instead of a Column Sometimes, you may want to give the user a Yes-or-No option to include some information in a report. For example, you might want to generally exclude records with a balance ...

    • Report Desk: Running Reports

      Release Date: 4/28/23 Version 8.6 Report Desk provides a powerful developing environment for Netcellent to deliver modern reports with rich elements of proportional spacing fonts, graphics, shading and line drawing. It allows us to output reports to ...