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.|
SELECT → TABLE → HIGHLIGHT THE COLUMN → RIGHT CLICK → INSERT COLUMN → LEFT, RIGHT
SELECT THE OBJECT → PRESS F4 (OR) CLICK VIEW OPTION AND SELECT PROPERTIES WINDOW
Properties for changing colors, fronts, borders, alignments, etc.
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
Make the same size
Centre in form
Tablix properties: These are the properties common for table and matrix → table → click at the top corner → select
Tablix properties → General
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
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
PARTY ID PARTY NAME PARTY LOC PARTY SALARY
[PARTY ID] [party name] [party loc] [party salary]
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.
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!|
Go to the group section → at click → group properties
Page Break options:
Between each instance of a group
Also at the start of a group
Also at the end of a group
Variables – Group variables which are used in certain grt
Advanced – set additional group properties
PARTY – REPORT:
Select group section → add group → row group → child group → Row group → child group
Group Name: [PARYT_LOC]
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
|MSBI Training||Jun 06 to Jun 21|
|MSBI Training||Jun 10 to Jun 25|
|MSBI Training||Jun 13 to Jun 28|
|MSBI Training||Jun 17 to Jul 02|
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.
Copyright © 2013 - 2023 MindMajix Technologies