Show TOC

Procedure documentationCreating a Crystal Report Using SAP MII Queries Locate this document in the navigation structure

 

You use this function to create a report from any SAP MII query datasource, and present it visually in the form of charts using crystal report designer. You can configure reports with SAP MII query types such as SQL, tag query, XML query, and so on as datasources to the report.

You can create the following types of reports:

  • Blank Report

  • Standard Report

  • Cross-Tab Report

  • Mailing Label Report

  • OLAP Cube Report

For more information on Crystal reports, see the SAP Help Portal at   http://help.sap.com   SAP Business Objects   BI Solutions   Crystal Reports.  

Caution Caution

SAP MII documentation supports steps to create a crystal report using Blank Report option. The other options mentioned in the above list contain a number of wizards to guide you through the creation of reports.

End of the caution.

Prerequisites

  • You have onfigured the crystal report connector.

  • You have pre-configured MII queries such as SQL or Tag in the SAP MII Workbench.

Procedure

To create a report using the Blank Report option, do the following:

  1. Choose   Start   Crystal Reports 2011  .

    The Crystal Report application appears.

  2. Choose   File   New   Blank Report  .

    The Database Expert screen appears.

  3. From the column Available DataSources, choose any existing MII connection under My Connections.

  4. Add the required MII query to the Selected Tables and choose OK.

    A Crystal Report page with the following fields appears:

    • Report Header

    • Page Header

    • Details

    • Report Footer

    • Page Footer:

  5. Choose   View   Field Explorer  .

    The Field Explorer window on the standard toolbar appears.

  6. Expand Database Fields in the Field Explorer dialog box and choose the fields.

  7. Drag and drop the fields to the Details section of the report.

  8. Choose   Report   Group Expert  .

    The Group Expert screen appears.

  9. From the Available Fields column, select the fields from the Report Fields and move to Group By column.

    The added group is displayed in the Design tab.

  10. To filter the data based on records or groups, Choose   Report   Select Expert   Record or Group or Saved Data  .

    The Select Expert screen appears.

  11. You can select the methods from the drop-down list for each field from the Select Expert screen.

    Note Note

    You can filter data and use formulas for each field using the Formula Editor tab. You cannot group the data.

    End of the note.

  12. Choose OK.

  13. Choose   View   Preview Sample  .

    The Preview Sample screen appears.

  14. You can select either All records or First N records, where N is a number specified by you.

    A report is generated along with fields and descriptions.