Customizing Values

Once you place an item, measure, or expression in the Selected Items: field, you can specify how that item's values are displayed. You can change the display format of the value or change the way in which an item is sorted.

For example, if the item contains dollar values, you may wish to place a dollar sign before the values. If the item contains text values, you may want them displayed alphabetically.

Changing the Numerical Format

You may change the display format for measures on crosstabs with numerical or date values.

To change the display format:

1.   Right-click the item in the Selected Items: field and select Format from the pop-up menu.

2.   Choose the appropriate format from the menu.

Changing the Sort Order

By default, values listed on a report or chart appear in the order in which they appear in the database. You may sort them in ascending or descending alphanumeric order if you wish.

To change the sort order:

1.   Right-click an item in the Selected Items: field and select Sorting Order from the pop-up menu.

2.   Choose either None, Ascending, or Descending from the menu.

If you choose Ascending or Descending, an arrow pointing up or down appears next to the item name, and the sort order number appears (1 for the first item to sort on, 2 for the second, and so on).

3.   Repeat steps 1 and 2 until you have sorted all of the items you are interested in.

Hiding an Item

Easy Reporter allows you to sort reports on hidden items. For example, you may wish to sort a report on Employee Salary, but not display that item on the report.

To hide an item:

1.   Right-click the item in the Selected Items: field and deselect Visible in the pop-up menu.

2.   That item does not appear on the report, but you may sort on it as described above.

 

   Note:


    This option is available for reports, but not for crosstabs and charts.


Deleting Items

To remove items from a chart or report, select one of the following options:

•   Click and drag the item from the Selected Items: field back to the Select Folder and Items: tree.

•   Right-click the item label in the Selected Items: field and choose Delete from the pop-up menu.

To remove individual values from a chart or report, see Displaying and Deleting the Selected Values on page 359.

Changing an Item's Label

When you select an item to display on a report, crosstab, or report, the name that appears on the chart or report by default is the same as the item's display label in the Selected Items: field.

To change an item's label:

1.   Right-click the item label in the Selected Items: field and choose Properties from the pop-up menu.

2.   Enter a new name into the Display name field and click OK.