Calendar Report in SSRS/EXCEL showing the Employee Leave Plan

Hi , I have a table like

tblEmployee

EmployeeName(nvarchar(50)) LeaveDate (Date)

Now i need to create a SSRS report or Excel showing the calendar view and the employee names against the dates when they are on leave.Does any one have a idea on how to get this done in ssrs.

Thank you in advance.

Kannan

asked Sep 14 '11 at 01:04 AM in Default

aRookieBIdev
2.1k ● 25 ● 42 ● 48

(comments are locked)

1 answer:

Just a quick Google got me a link to our sister site Simple-Talk. does this give you what you need, or at least a way of achieving it? http://www.simple-talk.com/sql/reporting-services/ten-common-sql-server-reporting-services-challenges-and-solutions/#hr

answered Sep 14 '11 at 02:09 AM

Fatherjack ♦♦
38.8k ● 56 ● 73 ● 104

thank you FatherJack .. The query seems to be little complicated.How do i apply the query for my table structure where I have the employee holidays.

Sep 14 '11 at 03:45 AM aRookieBIdev

you need to alter your query so that it returns a row for every day of holiday (not just the start and end dates), add columns to your query to give weekday, day and month values and then follow the report configuration in that link.

Sep 14 '11 at 04:16 AM Fatherjack ♦♦

(comments are locked)