article Creating custom reports with Crystal Reports

Article Contents


Overview

While up.time offers powerful reporting features, you may want to generate reports that use a specific set of data or a custom report format. Using Crystal Reports, you can retrieve data from the up.time DataStore and use it to create reports that meet your individual requirements.


Before You Begin

If you have not already done so, install the MySQL ODBC driver and create a data source to access the up.time DataStore. For more information, see Connecting to the up.time DataStore via ODBC.


Configuring a Report in Crystal Reports

To configure a report in Crystal Reports:

  1. Start Crystal Reports and click the Standard Report Wizard icon.

    The following window should appear:

  2. In the Data Source column of the Standard Report Creation Wizard window, expand the Create New Connection and ODBC (RDO) folders.
  3. Double-click Make New Connection.

    The Data Source Selection window should appear:

  4. In the Data Source Name list, click up.time and then click Next.
  5. When prompted for a user ID and password, enter reports and reports and then click Finish.
  6. The connection will appear in the Make New Connection window. Expand the connection and double-click Add Command.

    The Add Command to Report window should appear.

  7. Enter the following code in the column in the left portion of the window:
    select e.display_name,avg(p.cpu_usr + p.cpu_sys + p.cpu_wio),  
           DATE(s.sample_time) from performance_samples,
    performance_aggregate p, entity e
    where s.id = p.sample_id
    and e.entity_id = s.uptimehost_id
    and s.sample_time > "2010-11-23"
    and s.sample_time < DATE_ADD("2010-11-23", INTERVAL 7 DAY)
    group by DATE(s.sample_time), e.display_name
    order by DATE(s.sample_time), e.display_name;
    

    This example will report on the CPU workload average for all systems over the seven day period from 2010-11-23 to 2010-11-30.

  8. Click OK after you change the range to suit your needs.

    The Standard Report Creation Wizard will start.

    Use the Wizard to control the appearance of the report.

  9. Select the fields to display in the report and then click Next.
  10. On the Grouping screen, select display_name to group the systems by their host names, and then click Next.

  11. On the Summaries screen, select avg(p.cpu_usr + p.cpu_sys + p.cpu_wio) from the Available Fields column, and then select Average from the dropdown list below the Summarized field column.

  12. Click Next.
  13. Select None for group ordering and click Next.
  14. Select No Chart and then click Next.
  15. Do not choose any subset information to display, and then click Next.
  16. Select the template that you want to use and then click Finish.

    Crystal Reports will now generate the report, as shown below:

  17. Save the report by selecting Save from the File menu.

Note: You may need to move or alter some of the report fields to meet your desired format.


Modifying the Sample Report

Download the sample report that was created earlier, open it locally with the settings intact and then modify the sample report as required by following these steps:

  1. Download the sample report using the link to the right.
  2. Open the file in Crystal Reports.
  3. Click Database / Set Datasource Location.
  4. In the Set Datasource Location window, click on the current data source.

  5. Locate your ODBC source in the bottom part of the window, click Update and then click Close.
  6. Click on Database / Database Expert.
  7. In the Selected Tables column, right-click on Command and choose Edit Command.

  8. Modify the report to suit your needs.

    Click OK when you are finished.

Attachments


article Reports - CR11.rpt (Size: 102.0 KB - Downloads: 2117)

Related Articles


Creating custom reports with Tableau

RatingViews
article

Use Tableau in conjunction with up.time's DataStore to generate custom reports.

By: uptime Support | Date Created: 12-14-2006 | Last Modified: 7-26-2011 | Index: 107

  17596

Creating custom reports with Microsoft Reporting Service

RatingViews
article

Learn how to query data from an MS SQL Server DataStore and create reports with Microsoft Reporting Services.

By: uptime Support | Date Created: 1-3-2007 | Last Modified: 7-6-2011 | Index: 113

  7842

Connecting to the up.time DataStore via ODBC

RatingViews
article

By: uptime Support | Date Created: 10-29-2005 | Last Modified: 7-14-2011 | Index: 019

  10317

Creating Excel Reports that use up.time Data

RatingViews
article

This article explains how to access the up.time DataStore and use up.time data in Excel reports.

By: uptime Support | Date Created: 10-30-2007 | Last Modified: 6-19-2012 | Index: 222

  8628

Creating Custom Service Monitors with Retained Data Collection

RatingViews
article

By: uptime Support | Date Created: 5-15-2006 | Last Modified: 12-16-2011 | Index: 067

  11276

User Comments



No comments have been posted.

Copyright © 2021 IDERA, Inc.   Legal   Privacy Statement