Producing Reports with Report Builder

The Report Builder tool included with SSRS is a Windows application that you, or authorized users, can launch directly from Report Manager. Report Builder provides you (or authorized end users) with a simplified interface for report development. Using Report Builder is an alternative to creating report definitions using BIDS or Visual Studio.

Creating a Report Model

Before you launch Report Builder, you must first create a report model. A report model is a specific type of an XSD schema called Semantic Model Definition Language (SMDL), which is generated for SSAS cubes by clicking a button in Report Manager. An SMDL model is a way to describe the underlying database in business terms, so the end user does ...

Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.