Requirement:
We would need to list the
employee salary in each page grouped by Department, this should follow the
following criterias:
a.
After every
department a page break should exists
b.
The footer should
display Page N of M type of details in every page.
a.
N – Is the page
number within the group
b.
M – Is the total
Number of pages for that Group
Example:
Assuming we have 5 Pages of
employee listing for the IT Department the Listing should show Page 1 of 5,
Page 2 of 5 ..upto Page 5 of 5. If we have only 1 page for the HR department it
should read Page 1 of 1.
Implementation:
1. The following the
Database Structure we are going to have and the query we are going to use.
2.
I am assuming
that we have the necessary expertise in creating the dataset, going to the next
step of adding a tablix to the report just by adding the necessary columns to
the tablix except the department.
3.
Add department to the Row Group as shown in the
figure below:
4.
Now select Dept_Description to the parent group
as given here, make sure you have selected Add Group Header:
5.
We have completed the grouping of report data by
Department, now your report will look like the following in the preview:
6.
We need to target our first requirement of breaking the page for each department, so
select the Row group properties as given below:
7.
Select page breaks in the Group Properties
window as given below:
8. Now if you see the report in Print Layout mode
the report would have achieved the 1st requirement which we have
outlined
We will see more about the next requirement in my next post.
