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

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

 

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