Report Builder & Report Models in Microsoft SQL Server 2005

by Gerald Schinagl

Overview

Report Models and Report Builder were introduced as a new piece of infrastructure in Microsoft SQL Server 2005 for the first time. This Book digs deep into the guts of the Structure of a Report Model and lines out the possible parameters and their influence for the user of Report Builder. All objects and their properties are described and give the reader information how they can deliver a good and usable Report Model to the user. The limitations and shortcomings of the product are displayed in this book as well as scenarios how to come around some of these limitations. The handling and usage of the Report Builder client for an information worker is described. Besides the common usage scenarios special emphasis is put and the navigation paradigm as well as filtering and grouping functionalities. To make up the whole picture security and the background-information of Reporting Services is described. Finally tips and tricks for common problems and scenarios will also be covered.

Product Details

ISBN-13:	9781419678912
Publisher:	BookSurge, LLC
Publication date:	12/19/2007
Pages:	168
Product dimensions:	5.98(w) x 9.02(h) x 0.36(d)

About the Author

Gerald Schinagl is a Solutions Architect and Project Manager at the Austrian Broadcasting Corporation (ORF). His responsibilities start with Archiving Solutions, Content Management Systems as well as innovative applications for the support of television-production. His first encounter with the IT world was the famous Commodore 64 and later on an AT-Machine with 1 MB of Memory - an enormous machine at that time. Gerald has been with SQL Server since Version 7.0 in all kinds of fields, starting from T-SQL over OLAP, ETL, Reporting and Data Mining.
For SQL Server 2005 Gerald has been in a very close Beta-program with Microsoft and developed a lot of new solutions in the classical database engine extending the database with own datatypes and aggregates as well as in the Business Intelligence field with end-to-end solutions using UDM, Analysis Services Integration Services, Reporting Services and Report Models