Home  >  Blog  >   MSBI  > 

Working with Report Models in SSRS

Rating: 4
  1. Share:
MSBI Articles

Report Models  are templates that contain data sets and data sources. It stores attribute that is 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(Semantic Model definition language)

If you would like to become SSRS (SQL Server Reporting Services ) certified professional, then visit Mindmajix - A Global online training platform: "SSRS Certification Course". This course will help you to achieve excellence in this domain.

Working with Report Model

Real-time usage:

It acts as a template to set of tables and columns. So no need to create a 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 a 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 the report manager and observe the report.

Related Page: SSRS – How To Create Dynamic Reports Using Parameters

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

  • Report builder 1.0
  • Report builder 2.0

2008 supports both these versions.

It uses a report model to generate reports. So there is no need to create data sources 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 the Design Report from the menu → create a file and click the run report option to run the report

 MindMajix YouTube Channel

Filtering the report:
 Go report menu → Click Filter.
(or)                                                         [Hyd]
Go to Toolbar → Click Filter → click party with: → select from fields →
party loc equals

Frequently Asked SSRS Interview Questions & Answers

Sorting and Grouping:

Sorting and Grouping

View Menu

Format menu:

Number, Alignment, Font, border, fill

Report menu:
                                   New field
                                   Sort and Group {
                                   Report properties }

The report builder supports below type of data regions:

  1. Table
  2. Matrix
  3. 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

  • Lockdown 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 a menu                    → Text box
→ Picture
→ Total Row count

Creating new fields:

Report menu → new field → specify field name → specify a 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.

Explore MSBI Sample Resumes! Download & Edit, Get Noticed by Top Employers!    Download Now

Join our newsletter

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
MSBI TrainingMay 30 to Jun 14
MSBI TrainingJun 03 to Jun 18
MSBI TrainingJun 06 to Jun 21
MSBI TrainingJun 10 to Jun 25
Last updated: 29 May 2023
About Author
Remy Sharp
Ravindra Savaram

Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

Recommended Courses

1 /15