question

aRookieBIdev avatar image
aRookieBIdev asked

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
excelssrs-2008reportingcalendar
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Fatherjack avatar image
Fatherjack answered
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
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

aRookieBIdev avatar image aRookieBIdev commented ·
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.
0 Likes 0 ·
Fatherjack avatar image Fatherjack ♦♦ commented ·
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.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.