Report

Title

The title is shown across the top of the report. You can either hard-code a title here, or use substitutions so that the user can supply all, or part of the title. For example, setting the title to
${Title}
means the user can define the Title parameter and that value will be used. You can set a default title like this:
${Title##This is the default}
You can also combine several substitutions to form a title:
Sales Report for ${Year} by ${User}
See the Elixir Repertoire manuals for a complete description of substitution options.

Timeout

The timeout option controls how long results will be cached. The default timeout is Session. This means that if the same report data is used later in the same logon session, then a cached copy will be used in order to reduce the database load and provide a faster response. If data is changing more frequently and you want to avoid having to log out and log in again to see changes, you can set the number of seconds for which the cache is valid. Setting the timeout value to 0 seconds means the values will always be loaded from the database.

DataSource

An AdHoc report needs a connection to an Elixir Repertoire DataSource. You can use the chooser button [...] to the right of the entry field to choose a datasource from the server repository. If you need to combine several datasources together in one report, then you should create a Composite datasource, which will allow you to join different kinds of data together, as well as perform useful tasks such as filtering and removing of duplicates and nulls from the records before they are passed into the report.

Parameters

Some datasources may require parameters, for example user names or filter criteria that will restrict the number of records returned. If parameters are required, you will be prompted to enter values for them on this page. You have a choice to either define a constant value, for example:

Department=Admin
or you may use a substitution:
Department=${Dept}
in which case the user will be prompted to enter a value for "Dept" when the report session is first started.