Client-side Reporting with SSRS


SSRS attempts to address these issues with two main tools, Report Builder and Model Designer.

Before a user can create a client-side report, an analyst or technologist must create a report model. The report model is built with the aid of Visual Studio, and contains metadata about the underlying database.

The purpose of the metadata is to describe the relationships between the various tables in the RDBMS in terms of entities, attributes, and relationships (roles), which can then be used by Report Builder users to help them build ad hoc reports .

This helps to abstract the DBMS into business objects that the nontechnologist should recognize.

The second part of the equation is the actual Report Builder. The Report Builder is the tool used to create ad hoc reports.

It is a Windows forms-based .NET application that can be accessed through a URL (using the http://<localhost>/ reportserver /reportbuilder/reportbuilder.application URL, where <localhost> is the name of the computer that is running Report Server) or from Report Manager (using the http://<webservername>/reports URL and then clicking Report Builder).

Report Builder uses the report model to present the end user with the abstracted view of business objects. Although Report Builder is a powerful report-development application, Visual Studio provides many more features for report developers and is required to build models for Report Builder's consumption.



Microsoft SQL Server 2005 Reporting Services
Microsoft SQL Server 2005 Reporting Services
ISBN: 0672327996
EAN: 2147483647
Year: 2004
Pages: 254

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net