Show TOC

 Settings

Use

In the settings, you can determine:

  • whether the data is displayed as a list (basic list) or aggregated before output (statistics, ranked lists) and which output form is used,

  • whether the query is started using a selection screen,

  • which reference currency and which reference unit is used for statistics and ranked lists,

  • how many data records are displayed in a ranked list,

  • how data is exported to Crystal Reports,

  • which default settings are to apply when using fields with texts.

Prerequisites

If you want to export the data to Crystal Reports, you must have them installed on your local PC.

Activities

  1. On the InfoSet Query screen, choose Start of the navigation path Edit Next navigation step Settings End of the navigation path .

  2. The Settings dialog box is opened.

    On the Output tabstrip, you can determine the type of output list and the output format and also whether the query is to be started via a selection screen or not.

    On the Statistics/Ranked List tabstrip, you can determine the reference currency for the conversion of currency fields as well as the reference unit for converting units of measurement. In this tabstrip, you can also determine how many ranks are displayed in a ranked list.

    The tabstrip Crystal Reports allows you to determine how the Crystal Reports Export runs if Crystal Reports start directly from the InfoSet Query. You can create a new Crystal Report every time you export, or export the data to an existing Crystal Report on the local PC.

    If you export the results list of the query over the output list (ALV) to Crystal Reports, these settings are overridden and those settings that were made in the ALV apply.

    The tabstrip Default: Value/Text allows you to determine whether the value or the text is used when you select a field using either Drag & Drop or the check boxes. You can override these proposals by choosing the context menu when you select a field.

  3. Enter the required options.

  4. Choose .

Result

The settings are transferred for the current query.

When you have set up the Crystal Reports Export, the path for the Crystal Report template is saved with the query. The template itself is not saved with the query.

Note Note

It you want the query and the Crystal Reports template to be made available for other users, save the template in a directory that can also be accessed by these users. Otherwise, other users are not able to use the query and the template because the template is not saved with the query.

End of the note.