Report Builder and Report Models in Microsoft SQL Server 2005

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.