Developing and Deploying SQL Sever Apps on Windows Integrity

30 of 39
Reporting Services
• HP Integrity Server can play the role of Report Server database or Report Server or
both as shown below. In fact, for performance issues it is wise to separate the Report
Server and Report Server database.
• Reporting Services projects are developed from BIDS on a windows client computer,
separate from the report server. After your report looks the way you want, you can
publish it to a report server, where it becomes available for general use either on-
demand or subscription based.
¾ Report Builder
is a client-side application, web based visual environment,
that builds reports based on a report model using a simplified interface.
You can query data and create on-demand reports from Integrity Servers.
¾ Report Designer
and Report Model Designer are available from BIDS only.
¾ Reports Manager
on Integrity Server can be used to manage, configure
and secure the reports
¾ IIS will not be running on the Windows Client and so the Reporting
Services. However, from BIDS reports can be generated.
• There are several ways we can enhance the standard features provided in reporting
Services. These include Custom Data Processing Extension and ADO.Net Data Set.
Report Definition Language (RDL) is used to manage the reports.
• Report Services Configuration Tool
is used to set up the Report Server. The
following example shows how to set up a Report Server on Integrity Server.