Creating Enterprise Reports

Using BEx Report Designer, you can display the data for a query in an enterprise 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. From here on, we refer to enterprise reports simply as reports.

• 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

  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 .

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.

2. Designing the Report

You create the design for 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.

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 → SAP NetWeaver Business Warehouse → Settings for Reporting and Analysis → BEx Web → Set Standard Web Templates.

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 BW roles or as iViews in the portal.

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

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).

More information: Creating Reports with Report Designer .