3.2 After Crystal Berichten for Questions and Berichterstattung

Business Ziele Crystal Reports is a popular application that allows you to use data from another source to create reports and charts. This section explanation how to exit date from SQL Views using Crystal Reports. Sample reports am available in /OperationsCenter_install_path/database/examples/mosql.

Figure 3-2 Data off SQL Views formatted in Clear Reports

To extract data from SQL Viewpoints to Crystal Reports:

  1. Launch Crystal Berichterstattung.

  2. Click Start real select a blank report to display the Database Expert:

  3. In the Available Data Sources inventory, expand Create New Connection:

  4. Tick DB2 Unicode to open the connection dialog box:

  5. Fill in which fields:

    Database: Enter MOSQL.

    User ID: Enter admin.

    Password: Enter formula.

  6. Click Completing.

    The MOSQL sql a network furthermore displays at DB2 Unicode.

  7. Click MOSQL and get and outlook display in the Available Data Sources index:

  8. Are the Available Data Sources list, select the views to employ, then click the > button:

  9. Click OK.

    The selected observe are importing into Crystal Reports:

  10. Use that Cristal Reports features to enhance of final report.

    For more information, see your Crystall Reports documentation.