Working with Report Models in SSRS

Working with Report Model

These are templates that contain data set and data sources. It stores attributes which are supposed to display in various reports. Before taking attributes from various tables the tables should contain proper primary (or) Foreign keys. These model statistics are stored under SMDL

(Symantic Model definition language)

Real time usage:

It acts like a temp late to set of tables and columns. So no need to create data source, data sets on the fly for reports (dynamic reports)


1) Ensure tables are having valid keys in the source database

2) Go start menu → programs → open BIDS → new → project → select → Report model project → specify the name : temp_Models → view → solution explorer

Create a data source → RT click → data source view → Add new data source view → next → next → select the option “use current model statistics stored in the data source view” → next → RUN → Finish.

Go to project → Rt Click → properties → Deployment → Target

Server URL → Specify URL → click Ok

Build menu → Deploy Temp __ Models

Go to report manager and observe the report.

Working with Report Builder

This is designed to create and work with on the fly (or) dynamic (or) situational reports.

There are two versions of report builders are available

a) Report builder 1.0 and

b) Report builder 2.0

            2008 supports both these versions.

It uses report model to generate the reports. So there is no need to create data source and data set.

Go to report manager → Click report builder → Run → select report model and report layout (Table (columnar,), Matrix (cross Tab), Chart )  → Click ok.

Take Design Report from menu → create a file and click run report option to run the report

Filtering the report:

 Go report menu → Click Filter.

(or)                                                         [Hyd]

Go to Tool bar → Click Filter → click party with: → select from fields → party loc equals

Sorting and Grouping:

Go to report menu → click sort and group (or)

Go to Tool bar → Click sort and group


                                                 Sorty: Party loc                 Ascending

                                                            Page breaks between groups

                                                            <select required option>



Format menu:

Number, Alignment, Font, border, fill

Report menu:


                                   New field

                                   Sort and Group {

                                   Report properties }

Report builder supports below type of data regions

a) Table

b) Matrix

c) Chart

Report builder → Report properties

Choose the properties that you want to apply to this report

  • User sorting

                     Allow users to Sort the report data when they view it drill through

                           Allow users to drill to this report from other reports fixed headers

  • Lock down the report headings so that they are always visible when users scroll through the reports. Drill down


→ We can use below report items in the layout

Insert menu                    → Text box
→ Picture
→ Total Row count

Creating new fields:

Report menu → new field → specify field name → specify formula for each party (party income * 12/100) → ok

Report saving: One we save the report it saves directly in the report server (or) report manager.

Enroll for Live Instructor Led Online MSBI Training

0 Responses on Working with Report Models in SSRS"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.