Previous Topic   Next Topic

Enter Values

The Enter Values dialog helps you to specify multiple values for a parameter. See the dialog.

If the parameter's Enable the "All" Option property is set to true in Logi JReport Designer, the following two radio buttons are available. You can specify whether to use all values of the parameter or customize the values as you want.

• All
  If selected, it means that the parameter value result is all the values in the DBMS. This is translated in SQL to remove the parameter which may select more values than listed in the available values list.

  For example, when the parameter query is:

  SELECT CUSTOMERS.CUSTOMERID,CUSTOMERS.CUSTOMERNAME FROM CUSTOMERS where CUSTOMERS.CUSTOMERID>0 and CUSTOMERS.CUSTOMERID<4

  When you select to add 1, 2 and 3 as the parameter values, which are all the available values, the SQL is:

  (CUSTOMERS.CUSTOMERID IN ( 1,2,3))

  Run the same report again and this time check the All checkbox in the Enter Values dialog, the query is then:

  ( 1 = 1)

  In this case, you will get more customers even though available values are only 1 – 3.

  Note: When a multi-value parameter is inserted as a field in a report and All is selected as the value, the field will show the string "All". If the parameter allows type-in values, "All" means all possible values of the parameter data type; if the parameter does not, "All" represents all the values of the parameter that come from the DBMS.

• Custom
  If selected, you can customize the values you want to use for the parameter.

Available Values

Lists all predefined parameter values for selection. When the parameter is bound with a column, but the Display Column is different from the Bind Column, values of the Display Column are listed here.

Searches for values among the available values. After you type text in the search text box, the matched text in the available values will be highlighted. Select in the text box to close it.

Selected Values

Lists the values selected. The selected values are case sensitive.

This option is available when the parameter's Allow Type-in of Value property is set to true in Logi JReport Designer.

Select the button and enter a value manually in the text box, then press Enter to add the value to the Selected Values box. When the parameter is bound with a column, but the display column is different from the bind column, make sure the value you enter is that of the bind column. After finishing adding the values manually, select in the text box to close it.

Opens the Calendar dialog to specify a date and time value. Available only for Date, DateTime, or Time parameter which allows for type-in values and is not bound with any column.

Adds the selected values from the Available Values box to the Selected Values box.

Removes the selected values from the Selected Values box.

Adds all the selected values from the Available Values box to the Selected Values box.

Removes all the selected values from the Selected Values box.

OK

Applies the selected values to the parameter and closes the dialog.

Cancel

Does not retain any changes and closes the dialog.

Help

Displays the help document about this feature.

Back to top

Previous Topic   Next Topic