Providing Values for Query Parameters

 Go to contentsContents
nextExporting Data
backViewing Reports

When you run a report, that uses variables, the user will be asked to supply values for these variables. A dialog appears, that prompts for these variables. If the variables are all single line values (Numbers, Dates, Strings), then a simple dialog will appear. If query variables require selection from a list, then the variable input dialog will use a wizard based layout.

Simple Values Numbers, Strings, Dates

Query variables are introduced by filters or formulas. To see how a query variable is defined see see alsofilter/formulaediting, seequery variable definition

date input
  1. ReportWeaver shows edit fields or selection boxes for the values to be supplied. The initial value can be configured in the seequery variable editor .
  2. To enter a date value, type it in the format of your locale, or pop up the date picker.
  3. You can cycle through the years or enter a value for the year.
  4. You can cycle through the month or enter a value for the month.

The variable values are reused when you refresh a report from the run template.

When you use interactive picks or selections (i.e. the user selects elements from the database interactively) ReportWeaver displays a wizard for variable input.

Single Item Pick

single pick dialog
  1. The tabs show you the variables that must be filled. (here it is only one)
  2. You can search for values in the list by typing a string to search.
  3. You can search for items that must start with your search text.
  4. You can select one item before you can pressNext or Finish.

Single item picks return a single object, not a collection. They are introduced in view definitions.

Multiple Item Selection

multiple item selection
  1. The tabs show you the variables that must be filled. (here it is only one)
  2. You can search for values in the list by typing a string to search.
  3. This is the list of available values.
  4. Use the shift buttons to add or remove items from your result list.
  5. This is the resulting list.

Variables in the Runtime API

When you run reports from the API you can also pass variable values via the API. Any requred variable that has not been set in the call is then queried from the user. For details see seeProgramming the runtime API.

If you are running in a non interactive environment (headless/server side), then an exception is thrown if not all variables have been set through the API.

backViewing Reports Go to contentsContents nextExporting Data