Report Desk: Optional File Input Parameter

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 Operator to IN or NOT IN as in the example below.  Then click the Info icon:


Then make the appropriate selections in the Allow FileName for Input Values section of the dialog:

  • Allow File Input?  Check this if you want to allow file input for values.
  • With a Header Row?  Many .CSV files are generated with a header row that provides titles for the columns.  If you will be using such a header row, check this box.  It will skip the first line in the file.
  • Suggested File Extents:  The most common types of input files are .CSV and .TXT.  That is the default for this field.  However, you can change the list to match your needs.
When you save these selections and save the report definition, the input field will look like this:


As the ToolTip suggests, you can enter a list of comma-separated values here, or type in a filename, or use the File Search Button (... ) to select a file.  As you type in a filename, the Status Message and ToolTip change to let you know about the filename you are entering:


When a complete filename is entered and the file exists, the ToolTip and Status Message tell you about the file:
  • Number of lines in the file
  • Whether or not a header is expected
  • The first few characters of the first line in the file
  • The first few characters of the second line in the file


When an existing filename is entered, there is a View button enabled, and, if there is an application registered for the type of file entered, an Edit button is enabled (both in right-most red box above).  You may press the View button to see the contents of the file or press the Edit button to edit it.

When an existing filename is selected, the SQL statement will be generated by selecting the first column of the lines in the file:


EL850RD, ELRW_SYRPTUDR
JEG


    • Related Articles

    • 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 ...
    • Feature: Report Desk AR Statement

      Release date: 5/5/2023 Elliott Version: 8.6 Overview Beginning with Elliott version 8.6, there is a new ability to create more professional looking Accounts Receivable statements. The following standard features are included: Accounts are ...
    • 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 ...
    • 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 ...
    • 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 ...