Limiting the Items to Display

You can restrict the items along the x-axis to a few specific items, or you can ask the report user to select the items to display.

Easy Reporter allows you to limit the items to display in three ways:

•   By retrieving a list of values from the database.

•   By specifying query conditions.

•   By creating prompts.

These options are described in the following sections.

Selecting Values from the Database

Placing an item on a report or chart causes all of its values to be displayed on the report or chart. For example, choosing an item called Dept. Name places all departments on the report. If you would like to choose which departments to place on the report, you must retrieve the list of values for the item from the database.

To retrieve the list of values:

1.   Select the item in the Select Folder and Items: field.

2.   Click the plus icon next to the item whose values you wish to retrieve. The field displays a folder called List of Values.

3.   Double-click the List of Values folder. You are asked if you wish to retrieve the data.

4.   Click Yes. Individual values are displayed under the List of Values folder. This may take a few moments if there are many values to retrieve.

5.   Click and drag individual values from the Select Folder and Items: field onto the horizontal axis, vertical axis, or measures area in the Selected Items: field.

6.   The item names are displayed in the Selected Items: field with the number of values in parentheses. Icons for the values you chose also change colors in the Select Folder and Items: tree to show that they have been selected.

An example of this display is shown below.

 

   Figure 227: Easy Reporter Window Layout Tab

Displaying and Deleting the Selected Values

To see which values have been selected:

1.   Right-click the item label in the Selected Items: field.

2.   Choose Selected Values from the pop-up menu. The list of values is displayed.

3.   If you wish to delete a selected value, select the value and click Delete.

When an item is deleted, the icons for the values in the Select Folder and Items: field change back to their original colors.

Entering Query Conditions

Easy Reporter allows you to specify one or more query conditions to limit the information displayed on a report or chart.

Specifying Simple Conditions

To specify a simple condition for an item:

1.   Click and drag the item from the Select Folder and Items: field into the Query Conditions: field.

2.   The Condition Builder window is displayed, as shown below.

 

   Figure 228: Condition Builder Window

3.   Select a condition (for example, is greater than) from the drop-down list.

4.   Select value and enter a value into the text box.

5.   Click OK.

The condition appears in the Query Conditions: field.

Specifying Complex Conditions

Complex conditions are simple conditions joined by boolean operators (AND or OR). To specify a complex condition:

1.   Add a condition as described in Specifying Simple Conditions on page 359.

2.   Click and drag another item from the Select Folder and Items: field directly on top of the first condition in the Query Conditions: field.

3.   The word AND appears connecting the two conditions and the Condition Builder window is displayed.

4.   Select a condition (for example, is greater than) from the drop-down list.

5.   Select value and enter a value into the text box.

6.   Click OK. The condition appears in the Query Conditions: field.

7.   To change the AND to OR, right-click the AND and select OR from the pop-up menu.

Repeat steps 2 to 7 until the condition is complete.

Deleting Conditions

To delete a condition or part of a condition:

1.   Right-click the condition or part of the condition in the Query Conditions: field.

To delete an entire complex condition, right-click the word AND or OR.

2.   Select Delete from the pop-up menu.

3.   Select Yes when asked to confirm the action.

Creating Prompts

When you create a report, you do not have to specify all the conditions right away. Instead, Easy Reporter can prompt whoever runs the report for the information to be displayed. You do this by creating a prompt.

Prompts are a special kind of condition in which the user chooses the values to display on a report or chart at the time the report is run. You create prompts in the same way you create conditions.

To create a simple prompt for an item:

1.   Click and drag the item from the Select Folder and Items: field into the Query Conditions field. The Condition Builder window is displayed.

2.   Select a condition from the drop-down list.

3.   Select the Prompt radio button, then click Define. The Define New Prompt window is displayed, as shown below.

 

   Figure 229: Define New Prompt Window

4.   Enter a prompt message and select the prompt conditions as described in the following table.

Table 73: Prompt Conditions

Condition

Description

Prompt Message

Sets the message the user sees when they run the report. You may accept the default message or enter your own.

Available Values

Specifies a list of values that the user can select from at runtime. The Load Values button retrieves all values from the database and places them in this list. The Remove All button removes all values from this list. The Select All button selects all values in this list. If the Available Values list does not list a value you want to select (perhaps because the value is not used in any records at the moment, though it might be in the future), you can enter the value in the text box, then click Add to list.

Allow multiple value selection

When selected, the user can choose more than one value at runtime.

Allow manual entry of values

When selected, the user can type in a value by hand instead of selecting it from a list. This is useful if the desired value is not in the provided list, for example, if the user is being prompted for an employee's last name.

Add single quotes around values

The value selected by the user is surrounded by single quotes when it is used in the condition. This is useful for character data.

Allow fresh lookup of values when run

When selected, the user can retrieve up-to-date values from the database at runtime. This is useful if the item contains values that change often.

5.   You may create complex prompts and delete prompts in the same way you create and delete conditions.

6.   Click OK to close this window. Click OK again to close the Condition Builder window.