Mindmajix

Report and Group Variables in Reporting Services

Recommended by 0 users

Variables

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

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

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.

 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 source (according to situation)
  2. This field is usable across anywhere without rewriting calculation

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:

Screenshot_124

Tool box → image option → take image → Embedded → Import image → Image properties → general → name → size → In Display → select the option fit to size

 Screenshot_125

For expression → RT click → Text box properties → Expression

  1. Globals! Reportname & VBCRLF & Globals! Execution Time
  2. Globals! Pagenumber & “_TO_” & Globals! Total pages
  3. Total Income::” & Sum (Reportitems (“Partyincome”).Value)

Enroll for Live Instructor Led Online MSBI Training


 

0 Responses on Report and Group Variables in Reporting Services"

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.