Page History

...

Configuring a report using Microsoft Reporting Services

To configure a report in Microsoft Reporting Services:

1. In Microsoft Visual Studio .NET, right-click Reports, and

...

1. select Add New Report. The Report Wizard starts.

...

1. Click Next.
2. Select Shared data source, and then select the database from which you are retrieving data.
   Image Added
3. Click Next.
4. Enter the following query string:
   

   Code Block
   language sql
   SELECT e.display_name AS 'Description',

...

1. AVG(p.cpu_usr + p.cpu_sys + p.cpu_wio) AS 'CPU Workload Average',(CONVERT(char(10),s.sample_time,102)) AS 'Date'

...

1. FROM performance_sample s, performance_aggregate p, entity e WHERE s.id = p.sample_id

...

1. AND e.entity_id = s.uptimehost_id AND s.sample_time > '

...

1. 2023.11.29'

...

1. AND s.sample_time < DATEADD(day,5,'

...

1. 2023.11.29')

...

1. GROUP BY (convert(char(10),s.sample_time,102)), e.display_name ORDER BY (convert(char(10),s.sample_time,102)), e.display_name;

   This example

...

1. reports on the CPU workload average for all systems over the five day period from

...

1. 2023-11-29 to

...

1. 2023-12-03 (simply change the dates or the interval as required).
2. Click Next after you change the range to suit your needs.
3. Choose the Matrix option, and then click Next.
   Image Added
   The Design the Matrix window appears, which enables you to change the way in which data is arranged in the report.
4. In this example:
   • Description is moved to the Rows field.
   • Date is moved to the Columns field.
   • CPU Workload Average is moved to the Details field.
5. Click Next.
6. In the Choose Matrix Style window, select Compact. The Design the Matrix window appears.
   Image Added
7. Select to display all of the fields in the report, and then click Next.
8. Click the Preview Report check box at the bottom of the page.
   Image Added
9. Click Finish to generate a preview of the report.

Publishing a report to IIS

...