Blog

  • Home
  • MSBI
  • How to Create Table Report in Reporting Services - MSBI

How to Create Table Report in Reporting Services - MSBI

  • (4.0)
  • | 1254 Ratings

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
 Working with 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!

Subscribe For Free Demo

Free Demo for Corporate & Online Trainings.

Ravindra Savaram
About The Author

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.


DMCA.com Protection Status

Close
Close