O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required