This section describes how to build, deploy, manage, and manage reports. It also provides descriptions of the data services stored procedures, which provide the data to reports.
Users of this section should be familiar with the following tools and concepts:
- Microsoft Visual Studio
- Microsoft SQL Server Reporting Services
- Relational database concepts (SQL)
- Business intelligence and reporting concepts
To better understand how reports work, you should be familiar with the following concepts. Reports are sometimes referred to as report templates.
- Report Definition An XML file that specifies what the report does and how it looks. It is a template for the user to populate with parameters. There is no data in a report definition file. This is the file that users see in the Report list in the General tab when creating or editing report.
- Parameterized Report Definition A report definition with user-defined parameters and an
association to an item or a resource
team. There is no data in the parameterized report definition. This is the state
of the reports listed in a user's Reports tab.
- Report Instance (Rendered Report) A parameterized report definition that is populated and viewed by a user. A report instance contains data based on user-defined parameters. Users can redefine some of the parameters and view the report with these new parameters. The newly refreshed report is still a report instance. This is the state of the report when a user views a report on the Reports list. When a user closes the report window, the data is not saved. A report instance is not a document. It is a presentation of data in the report definition file.
- Report A report instance that is printed or exported to an output format such as PDF, HTML, CSV, .tiff or Microsoft Excel. When a user prints or exports the report instance to one of the formats listed, the report instance becomes a report.
- Scheduled Reports Reports that a user can specify to be run on a schedule, exported to an output format, and stored in the Documents Manager.
The following software is required for reporting:
- Microsoft Visual Studio
- Microsoft SQL Server Reporting Services
- Software configuration prerequisites: The OLE DB Provider, configuring a data source for working internally, and valid permissions as well as in Microsoft SQL Server Reporting Services.
Copyright © 2003–2011 Serena Software, Inc. All rights reserved.