We use the calendar in SP2013 to collect information when a user is away on holiday and when there will be any visitors. It works fine as a calendar but now struggling to generate a report in SSRS to show all the days when on holiday.

Example; this is what calendar looks like in SP2013

enter image description here

I am struggling to show all the consecutive days from Friday 03/02/2017 until 17/02/2017.
In this case, the Reports is just pulling the start date =Fields!Start_Time.Value

enter image description here

enter image description here

As you can see, from the result above, it does not show all the consecutive days but only the start time. Yes, you may say "...well you specified to show from the start time" but my question is here how to modify it so it shows HOLIDAY on all the dates relative to the start & end date.

Any ideas / suggestions?

The SSRS Query Type is as following:

<RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <ListName>Staff Movements</ListName>
    <FieldRef Name="Title" />
    <FieldRef Name="Location" />
    <FieldRef Name="EventDate" />
    <FieldRef Name="EndDate" />
    <FieldRef Name="Category" />
    <FieldRef Name="User" />
    <FieldRef Name="Department" />
    <FieldRef Name="Position" />
    <FieldRef Name="Visitors_x0020_Name" />
    <FieldRef Name="Visitors_x0020_Business" />
    <FieldRef Name="Visitors_x0020_purpose" />
    <FieldRef Name="Visitors_x0020_Visiting" />
    <FieldRef Name="Created" />
  • Anyone please help me :(
    – Bucki
    Commented Feb 7, 2017 at 10:52
  • pleaseeeeeeeeeeeeeeeeeeeeeeeeeeeeee help
    – Bucki
    Commented Feb 9, 2017 at 8:32
  • Since it has been a couple years since the original post I am wondering if anyone was able to write the code needed to retrieve all occurrences (recurring or single) and apply it to their Report Builder Report.
    – MissyB
    Commented Jan 24, 2020 at 18:58

1 Answer 1


I think you want to retrieve the information from Calendar which are mainly recurrent events to show in the reports.

If you specify the calendar start date and end date (2 weeks). It actually preset only one record in the list If you retrieve directly from the list you can only see one item coming into a form or a report.

There is a field call “RecurrenceData” which hold the complete information of that event in xml format.

You just have a look into this to understand https://fatalfrenchy.wordpress.com/2010/07/16/sharepoint-recurrence-data-schema/

So you have to build a logic to display one event into multiple records in the report and do filter for it.

You have to add the VB logic to convert that xml into a multi data in Report Properties under “Code” section and you can also reference property to solve your problem.

Please see the example in this link https://technet.microsoft.com/en-us/library/dd255294(v=sql.100).aspx

Please let me know if my solution suits for you

  • would be happy to grant you access to my PC via webex where you can see exactly what I mean and try it out ... ?! let me know if its ok with you. Thanks
    – Bucki
    Commented Mar 13, 2017 at 14:16
  • can we have a webex meeting about this pls?
    – Bucki
    Commented Mar 17, 2017 at 12:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.