Using Crystal Reports for Queries and Reports

Business Objects Crystal Reports is a popular application that allows you to use data from another source to create reports and charts. This section explains how to extract data from SQL Views using Crystal Reports. Sample reports are available in /OperationsCenter_install_path/database/examples/mosql.

To extract data from SQL Views to Crystal Reports:

  1. Launch Crystal Reports.

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

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

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

  5. Fill in the fields:

    Database: Enter MOSQL.

    User ID: Enter admin.

    Password: Enter formula.

  6. Click Finish.

    The MOSQL database is connected and displays under DB2 Unicode.

  7. Click MOSQL and all the views display in the Available Data Sources list:

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

  9. Click OK.

    The selected views are imported into Crystal Reports:

  10. Use the Crystal Reports features to enhance the final report.

Anjali Punjab

Anjali Punjab is a freelance writer, blogger, and ghostwriter who develops high-quality content for businesses. She is also a HubSpot Inbound Marketing Certified and Google Analytics Qualified Professional.