Selection Options for Setting Report Parameters

Reports
Reporting Fundamentals
Selection Options for Setting Report Parameters


Contents
Overview
Multiple Selection Button
Selection Options Button

(See also: Selection Options for Cost Element Groups and Selection Options for Profit Center Groups)

Overview

Selection options refer to SAP buttons that allow you to enter different variations of numbers or values when you set parameters for a report. The Multiple Selection button Multiple Selection button lets you enter more than one range of numbers such as cost centers or dates. You can also exclude values from ranges. Another feature of the Multiple Selection button is that it allows you to enter individual nonconsecutive numbers.

The Selection Options button, which appears as Selection Options button on some reports and Selection Options button on others, lets you specify numbers that are greater than, less than, not equal to, and other combinations. For example, you can run a report for all cost centers less than or equal to 1671100. You can also exclude these numbers; all cost centers not less than or equal to 1671100. This button has a more limited use on reports than the Mutliple Selection button.

screen capture:  Selection Options and Multiple Selection buttons

CAUTION!

Be very careful when using this type of selection criteria, especially if you have authorization for many profit centers and/or cost objects. Even if your authorizations are limited, avoid unintentionally entering broad selection criteria. This could cause the report to run for an extremely long period of time.

 

top

 

Multiple Selection Button

The Multiple Selection button Multiple Selection button allows you to use these types of selection criteria for reporting:

include or exclude individual nonconsecutive numbers, such as cost centers 1347700 and 1501906

include or exclude multiple ranges of numbers, such as cost center 1501906 through 1501915

You can also use the selection criteria in combination with each other. For example, you could run a report on cost centers 1671100 through 1673400 but omit 1672600 and 1673300 from these ranges.

You can use the Multiple Selection button Multiple Selection button either before or after entering your numbers.

Note

If you entered the numbers before clicking on the button, they will already be displayed on the Multiple Selection screen.

Result: The "Multiple Selection for ..." screen appears.

screen capture:  Multiple Selection screen

The screen has tabs which are colored-coded; green to include values, red to exclude values.

TAB

 

USE

green

Single vals

include single values

green

Ranges

include ranges of numbers

red

Single vals

exclude single values

red

Ranges

exclude ranges

You can use these tabs in combination with each other. For example, if you wanted to run cost centers 1671100 through 1673400 but omit 1672600 and 1673300 on the Summary Statement.

1. Click on the Multiple Selection button Multiple Selection button to the right of the Cost Center field.

2. Click on the green Ranges tab and type in 1671100 to 1673400. See below.

screen capture:  Multiple Selection for Cost Center ranges

3. Click on the red Single vals tab and type in 1672600 and 1673300. See below.

screen capture:  Multiple Selection for Cost Center exclude single values

To delete your entered values on the screen, click the Delete Selection Line button Delete Selection Line button (bottom of screen).

4. When you are finished, click the Execute button Execute button on the bottom of the window.

Result: You return to the report entry screen where the first number you entered is displayed in the appropriate field. The Multiple Selection button turns green (see below) after you make your selections. Click on the button if you want to see the tabbed screens again.

screen capture:  Multiple Selection for Cost Center on SS

5. After completing the report entry screen, click the Execute button Execute button to run the report.

top

 

Selection Options Button 

Using the Selection Options button, you can choose numbers that are equal to, not equal to, less than, greater than, less than or equal to, or greater than or equal to the number or numbers that you specify. These types of selection criteria are useful when you want to view data for many cost objects in one report run; for example all cost objects less than1300100.

1. Enter a number in one of the fields.

2. Click on the Selection Options button button.

Result: The "Select by Initial Value" window (Mac) or "Maintain Selection Options" (PC) is displayed.  

 screen capture:  Select by Initial Value

3. (optional) If you want to exclude the value, click the Exclude from selection button on the bottom of the window. The options turn red.

screen capture:  Select by Initial Value (exclude from selection)

4. Click on the options that you want to use; greater than or equal to, less than, not equal to, etc.

5. (optional) To delete the value you just entered from the report screen, clidk the Delete line button Delete Selection Line button on the bottom of the window.

6. Click the Enter button Enter button .

Result: You return to the report entry screen where the Select button is displayed next to the field you just entered. If you chose "Select," the button is green with the symbol inside. If you selected "Exclude," the same button is red.

7. After completing the report entry screen, click the Execute button Execute button to run the report.

top