Specifications

www.evisions.com Argos - Argos Report Writers Guide Page 79 of 118
Document Version 1.0 Last Updated 10.18.2010
Adding Parameter Input to the Report
Example 9
Banded Reports obtain query results from the DataBlock to report on the contents of a
database. Other information not contained within the Report Query can be obtained and
inserted into your report, including items such as:
Date and time the report was generated
Information about the database connection such as DataSource name, Driver file
name and version, SQL format, etc.
DataBlock name and path
Report name and path
Username and user type
The search parameters chosen from the DataBlock form.
To obtain this information you need to add an expression field into the desired band
using methods you are now familiar with. This is done by clicking the “Add an
expression field” icon on the Band Report Editor toolbar, then clicking within the band
where you want the field to be placed.
Figure 135Adding an expression
The Expression dialog boxes above are displayed. From the Expression Wizard, click the
Variable button which displays the list of variables that can be inserted into the band.
Variables preceeded with a $ are system variables. Variables without the $ are items
selected from the DataBlock form used to create the report.
Adding the selections made within the
DataBlock form to the report provides
very useful background information used
to create the report
The “Add an Expression Field” icon within
the Band Report Editor toolbar