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
SELECT THE OBJECT → PRESS F4 (OR) CLICK VIEW OPTION AND SELECT PROPERTIES WINDOW
Properties for changing colors, fronts, borders, alignments etc.
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
Fore ground color
Make same size
Centre in form
Subscribe to our youtube channel to get new updates..!
Tablix properties: These are the properties common for table and matrix → table → click at the top corner → select
Tablix properties → General
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
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
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 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.
Group by: [party loc] → mark the options → click ok
Taking subtotal (Group by total) → go to group footer section and select income
Working with group properties:
Go to 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:
TAKING SUB GROUPS:
Select group section → add group → row group → child group → Row group → child group
Group Name: [PARYT_LOC]