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 would like to become a MSBI certified professional, then visit Mindmajix - A Global online training platform: “MSBI Certification Training” Course. 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 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

  • Subscribe to our youtube channel to get new updates..!

    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

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!