PowerAccess

PowerAccess is a Web-based reporting and management tool that provides the capability to create and design ad hoc reports. You can select from a variety of report layouts and then drag and drop fields into the design area to build table, matrix, or chart reports. PowerAccess leverages new technology to enable users to query data easily and present results in a customized format.

Report Builder

Report Builder is an easy-to-use application that allows users to create and design ad hoc reports. Using Report Builder, you can select data and design reports without having to understand how or where the data is stored, nor any programming language, in order to create reports. Users need only be familiar with the business model of the data.

Using Report Builder, you can create table, matrix, or chart reports. The data can be manipulated by filtering, grouping and sorting, or working with formulas, to specify parameters, and customize the data. In addition, you can add images to your report layout and design your reports to use colors, fonts, lines, and different formats. Once you save reports to the report server, they can be exported to the local computer as a TIFF, PDF, Excel, or HTML file.

Report Manager

Report Manager is a Web-based report access and management tool that allows you to administer a single report server from a remote location over an HTTP connection. Plus, it provides report viewer and navigation features.

Reports Manager includes the capability to:

• View, search, print, and subscribe to reports
• Create, secure, and maintain the folder hierarchy to organize items on the server
• Configure the role-based security that determines access to items and operations
• Configure report execution properties, report history, and report parameters
• Create report models that connect to and retrieve data from a Microsoft SQL Server Analysis Services data source or from a SQL Server relational data source
• Set model item security to allow access to specific entities in the model, or map entities to predefined click-through reports that you create in advance
• Create shared schedules and shared data sources to make schedules and data source connections more manageable
• Create data-driven subscriptions that roll out reports to a large recipient list
• Create linked reports to reuse and repurpose an existing report in different ways

Report Manager also allows you to browse the report server folders or search for specific reports. Plus, you can view a report, the general properties, and past copies of the report that are captured in report history. Depending on your permissions, you may also be able to subscribe to reports for delivery to an e-mail inbox or a shared folder on the file system.

System Requirements

• Windows Server 2003 Service Pack 2; Windows Server 2008; Windows Vista Service Pack 1; Windows XP Service Pack 3
• Microsoft .NET Framework 2.05 and 3.5
• Microsoft Installer 3.1 and 4.5
• Report Builder 2 (thin client from BI server)
• Business Intelligence Development Studio
• Adobe Acrobat Reader
• Excel 2003 to 2007 (2007 is recommended)
• OLE DB 10
• OWC 11
• Internet Explorer 6 to 8
• MSXML 6.0