Creating Query Parameters

Parameters allow prefiltering report data based on data provided on the Web. It can be any value from the Field List, Properties window, or FilterString Editor. The created parameter appears in the Field List's Parameters node.

To create a report parameters the following:

1. Select a report and click the Parameters property in the Field Section.

2. Click Add in the invoked Report Parameters Editor dialog to add a new parameter. Specify parameter options:

   1. Name. The name by which you can reference a parameter in a report. Note that report parameters should have unique names.

   2. Description. A parameter description that appears on a report's Print Preview in the Parameters panel.

   3. Visible. Specifies whether a parameter is visible in the Parameters panel.

   4. Type. The type of parameter values. The following types are available: The type of parameter values. The following types are available:

      • String;

      • Date;

      • Number (16-bit integer);

      • Number (32-bit integer);

      • Number (64-bit integer);

      • Number (floating point);

      • Number (double-precision floating point);

      • Number (decimal);

      • Boolean;

      • GUID (Globally Unique Identifier).

   5. (Optional). It is possible to assign an expression to this option. The example below specifies an expression that shows/hides a parameter based on the value of another parameter.

   6. Enabled. Specifies whether a parameter editor is enabled or disabled in the Parameters panel. You can set this option to No to make a parameter's default value read-only.

   7. Allow Null Value.When the Allow Null Value option is enabled, you can leave the parameter's value unspecified.

   8. Allow Multiple Values. When the Allow Multiple Values option is enabled, you can specify multiple values for a report parameter.

   9. Select All Values. Enable the Select All Values option to use all elements from a custom set of values as a parameter's default value.

   10. Default Value. A parameter's default value. This value is displayed in the Parameters panel when you open a report's Print Preview. You can specify an expression for this option. For example, set this option to Now() to use the current date as a date parameter's default value.