Blog

How to Create Table Report in Reporting Services - MSBI

Creating Table Report

It displays data in rows and columns format It contains 3 sections
a) Header section: Here column Headings (or) Aggregate Information displayed.
b) Footer section (optional):- This section displays aggregate Information generally
c) Data section:-  Displays actual data presented to be in the report
Note: We can take one more section to split the data in the data section.
i.e group section

Adding Columns Left And Right:

SELECT → TABLE → HIGHLIGHT THE COLUMN → RIGHT CLICK → INSERT COLUMN → LEFT, RIGHT
 
PROPERTIES:
SELECT THE OBJECT → PRESS F4 (OR)
CLICK VIEW OPTION AND SELECT PROPERTIES WINDOW
 
Properties for changing colors, fronts, borders, alignments etc.
EG:-     Border colour → purple
Border style → Solid
Border width → 2pt
Back ground color → pale turquoise.
Front → century
Front size → 11Pt
Taking border to rows → highlight border section → press F4 → Select border color → changer to blue
Format menu
  • Fore ground color
  • Background color
  • Front
  • Justify
  • Align
  • Make same size
  • Horizontal spacing
  • Vertical space
  • Centre in form
  • Order
Tablix properties: These are the properties common for table and matrix → table → click at the top corner → select
Tablix properties → General
Name: party_table
Tool tip: party and address table Info
Data set name: DST_DBMSBI.
Page break options
Visibility               — Change displays options
Show                       :- Displays the object
Hide                         :- Hides the object
Show or hide based on an expression
Press the Fx
FREE Demo Class From Industry Experts - Enroll Now.!! MSBI training

Expression window:

Set expression for : Hidden
=IIF (Sum (Fields) PARTY INCOME. Value, “DST _ DBMSBI”) <5000000 False, trve)
Ex:- Display the report to the entire sum less than 50,00,000/-
Sol:- view the sol. At top →
Display can be tagged by this report item: →
This property can be useful while during drill down analysis
Ex:- Display the report when
Row section
  PARTY ID PARTY NAME PARTY LOC PARTY SALARY
[PARTY ID] [party name] [party loc] [party salary]
 
  Click here
FILTERS:  These are used to display the report based on filter condition
Ex:- Display the report where the party location is HYD
Filters  → Click add → Expression [partyloc] → = “HYD”
Sorting : Displays the corresponding column data in the specified sort order (ascending (or)descending)
Sorting → click add → sort by : [party loc] A to Z
Taking full total of the Income:
RT click → row section → Insert row → select outside group – below
Note:- By default the aggregation is sum. If we want to change the aggregation → go to text box expression and change it.
Taking groups: Generally we group the data if we are having duplications or to keep similar item records in a page
Eg:- HYD data in one page, banglore data in one page etc
  • Select row section → click add group → row group → parent group.
Tablix group
Group by: [party loc] → mark the options → click ok
  • Taking subtotal (Group by total) → go to group footer section and select income

Frequently Asked MSBI Interview Questions & Answers

Working with group properties:

Go to group section → at click → group properties
General:
Name: Loc_GROUP
Page breaks:-
Page Break options:
Between each instance of a group
Also at the start of a group
Also at the end of a group
  • Sorting
  • Visibility
  • filters
  • Variables – Group variables which are used in certain grt
  • Advanced – set additional group properties
 
PARTY – REPORT:
  • MUMBAI
  • HYDERABAD
  • CHENNAI
TAKING SUB GROUPS:  
Select group section → add group → row group → child group → Row group → child group
Tablix group
Group Name: [PARYT_LOC]
OK
           
Explore MSBI Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

RELATED COURSES

Get Updates on Tech posts, Interview & Certification questions and training schedules