Mindmajix

How to Create Table Report in Reporting Services

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

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

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

Screenshot_121

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

Enroll for Live Instructor Led Online MSBI Training


0 Responses on How to Create Table Report in Reporting Services"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.