CODEWITHSUNDEEP
reporting-servicesssrs-2008ssrs-tablixssrs-grouping
Feroz
Feroz

Reputation: 351

How to display data for individual days in SSRS

In my database, I have the data in the below format: Database View

and in my SSRS (2010) report, I need too show the data in the below format. enter image description here

My question is: We have data in the database for each bussiness date. In the report the data is shown horizontally (Sunday - Saturday).. So, when returning data from the DB, should I create individual columns for each day, update them with the data depending on the date and return it in individual day columns(individual columns for each day).. or is there a way we can do that in SSRS? The first option looks easier to do but not sure if it would be the right design.

Upvotes: 1

Views: 2160

Answers (1)

Anup Agrawal
Anup Agrawal

Reputation: 6669

Use Matrix.

Create row group of company, business unit and employee.

Create column group for BusinessDate. SSRS will automatically create columns for you.

Expression for the cell would be =SUM(HoursWorked)

Upvotes: 1

Related Questions