Home / MSBI

How to Create Table Report in Reporting Services - MSBI

Rating: 5.0Blog-star
Views: 2385
by Ravindra Savaram
Last modified: June 29th 2021

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

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.

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 color → purple

Border style → Solid

Border width → 2pt

Background 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:

  • Foreground color

  • Background color

  • Front

  • Justify

  • Align

  • Make the 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

Tooltip: 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

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 →

The 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 a full total of the Income:

RT click → row section → Insert row → select outside group – below

Note:- By default the aggregation is a sum. If we want to change the aggregation → go-to text box expression and change.

Taking groups: Generally we group the data if we are having duplications or to keep similar item records on a page

Eg:- HYD data in one page, Banglore data in one page, etc

  • Select row section → click adds 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

 Explore MSBI Sample Resumes Download & Edit, Get Noticed by Top Employers!  

Working with group properties:

Go to the 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 SUBGROUPS:  

Select group section → add group → row group → child group → Row group → child group

Tablix group

Group Name: [PARYT_LOC]

OK   

About Author

author
NameRavindra Savaram
Author Bio

 

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.