Reporting Services is a server-based solution that enables users to create and publish traditional, paper-based reports, as well as interactive Web-based reports.
Before you integrate Microsoft Dynamics AX and Reporting Services, it is important that you have a basic understanding of Reporting Services concepts. The following sections explain a few key Reporting Services concepts.
Report Manager
When you install and configure Reporting Services, a Web site called Report Manageris created. As the Microsoft Dynamics AX administrator, you will publish report models and reports to this site.
Report models
A report modelis a view of business data. The view has been isolated from other Microsoft Dynamics AX data so that it is relevant to users in a specific job. Users can create ad hoc reports using a report model.
For example, a manager who oversees customer relationships requires a report model that is based on customer data. Specifically, this manager needs a report model based on the customer table (CustTable) and other related tables. The manager will be able to create ad hoc reports using this report model.
As the Microsoft Dynamics AX administrator, you will publish report models to the Report Manager site.
Report Builder
Report Builder, a component of Reporting Services, is an ad hoc reporting tool that enables users to build their own reports. Users can build reports by dragging fields from a report model onto a report.