Home  >  Blog  >   MSBI  > 

Report and Group Variables in Reporting Services - MSBI

Rating: 5
  
 
3752
  1. Share:
MSBI Articles

Variables in SSRS

The variables are of two types. They are

  • Report variable
  • Group variable

1) Report Variables

This variable is used anywhere in the report
Navigation

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

                                                           ↓
                                              Expression window:

                                             Set the expression

                                                     *12/100

                                                       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

If you want to enrich your career and become a professional in MSBI, then enroll in "MSBI Training" - This course will help you to achieve excellence in this domain.

2) 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 the 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.

 MindMajix YouTube Channel

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

Note:

  1. This calculated field perform the operation while it is retrieving from the source (according to the situation)
  2. This field is usable anywhere without rewriting calculation
Related Article: Msbi Interview Questions

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 footerToolbox → image option → take image → Embedded → Import image → Image properties → general → name → size → In-Display → select the options fit to size

 RT click → Text box properties → Expression

For expression → RT click → Text box properties → Expression

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

 

Join our newsletter
inbox

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
NameDates
MSBI TrainingJun 03 to Jun 18
MSBI TrainingJun 06 to Jun 21
MSBI TrainingJun 10 to Jun 25
MSBI TrainingJun 13 to Jun 28
Last updated: 30 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