From the Query to the Report 

Use

You can display data for a query in a report optimized for presentation and printing. You have the option of specifying formatting for specific rows or columns in the report and designing the layout for the report.

Prerequisites

●      To create a report, you need a query (or query view) containing a structure in the columns.

●      Before creating a report, you need to decide how the report will be designed: 

The query fields can be positioned freely in a static section, because the static section is based on a query with two structures. Reports with static sections are often used in financial statements.

In a dynamic section, the number of rows is data-dependent. The layout options in dynamic sections are therefore restricted in comparison to static sections.

Note that static report sections also display report section with no data connection. These are usually the page header and/or page footer.

More information: Static and Dynamic Sections in Reports.

Procedure

...

1. Select Data Provider

You use the Insert Data Provider function to select a query or query view as the data provider. The selected data provider is automatically embedded into a report section and displayed with the relevant row patterns in the Report Designer design area.

If you want to create a new query or change an existing one, call BEx Query Designer from the Tools menu in Report Designer.

If you want to create a new query view or change an existing one, call BEx Web Analyzer from the Tools menu in Report Designer.

If you are using a data provider with an active hierarchy, a dialog box appears where you can choose how to format the hierarchy:

○       According to hierarchy levels

○       According to hierarchy node type

More information: Formatting Hierarchies

2. Designing the Report

You create the design of the report. The following options are available:

○       You can use standard formatting functions such as color, font, and border for individual report elements (cells or fields).

○       You can make layout changes, for example to adapt the height and width of rows and columns, to insert your own text or to realign query fields and text elements.

○       You can design the header and footer areas of the page and the report. You can drag images and your own texts into these areas or integrate totals fields for the query into the header area.

More information: Creating Reports with Report Designer.

3. Saving the Report

You save the report using the save dialog. Once you have saved the report, you can also use it in Web applications where you have inserted the Report Web item.

4. Executing the Report

You execute the report in the portal (Web). The report is displayed in the standard Web template for reports. You can set the standard Web template for reports in Customizing for the standard Web templates at SAP NetWeaver → Business Intelligence → Reporting-Relevant Settings →BEx Web →Set Standard Web Templates → Enterprise Report.

You can also create a print version of the report in Report Designer. The report is converted into a printable PDF document.

5. Publishing the Report

You can publish reports in BI roles or as iViews in the portal.

You can also call BEx Broadcaster from Report Designer and broadcast reports. More information: Functions in BEx Broadcaster

Result

You have created and customized a report that you can convert directly to a print version or display as a Web application in the portal (Web).