• Home
  • MSBI
  • Report and Group Variables in Reporting Services - MSBI

Report and Group Variables in Reporting Services - MSBI

  • (4.0)
  • | 2570 Ratings
Report and Group Variables in Reporting Services - MSBI


The variables are of two types. They are

  • a) Report variable
  • b) Group variable

Report Variables

This variable is used across anywhere in the report

Report Menu → Report → properties → variables → Add  → Name : PINC

                                              Expression window:

                                             Set the expression


                                                       Click Ok

Go to text box → rt click expression → expression window

              = fields! Partyincome.value * variables! PINC.value click ok

Note:- We cannot use in calculated or query fields

Inclined to build a profession as MSBI Developer? Then here is the blog post on MSBI TRAINING ONLINE.

Group Variables:

These are used within the same group only group → group properties → variables → add → NAME (PIC) → Expression (=12/100)

Creating a Query Field

  • These query fields added at data set level
  • No calculations allowed for these fields
  • Data set (DST_DBMSBI) → rt click → Dataset properties → Fields → add → select query field → OK

Adding calculated fields: 
Here the fields are created based on Calculation.

dataset properties → fields → Data set → rt click → Add.calculated field → Party Inc _DWH → expression → = fields! Partyincome.value *12.100 → OK


  1. This calculated field perform the operation while it is retrieving from source (according to situation)
  2. This field is usable across anywhere without rewriting calculation

Frequently Asked MSBI Interview Questions & Answers

Data Set Properties

a) Query:- 2) Name, Data source, query Type → text → Query: *Refresh fields → If the data in the sources change, to get the fresh data, this option is useful
b) parameters
c) fields
d) Options → Here options are case sensitive
e) Filter:- It filters the data of the dataset

Working with page header and footer:

 Working with page header and footerTool box → image option → take image → Embedded → Import image → Image properties → general → name → size → In Display → select the option fit to size

 RT click → Text box properties → Expression

For expression → RT click → Text box properties → Expression

  • Globals! Reportname & VBCRLF & Globals! Execution Time
  • Globals! Pagenumber & “_TO_” & Globals! Total pages
  • Total Income::” & Sum (Reportitems (“Partyincome”).Value) 
Explore MSBI Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

Subscribe For Free Demo

Free Demo for Corporate & Online Trainings.

Ravindra Savaram
About The Author

Ravindra Savaram is a Content Lead at 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. Protection Status