Report and Group Variables in Reporting Services - MSBI

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.

 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:

 Toolbox → image option → take image → Embedded → Import image → Image properties → general → name → size → In-Display → select the options fit to size

 

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)