I have connected an SRSS report (in SQL Reporting Services 2012) to a SharePoint 2013 list. Date fields all return #error
, but other fields return data successfully. May query looks like this:
<RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ListName>Absence Records</ListName>
<ViewFields>
<FieldRef Name="StaffMemberName" />
<FieldRef Name="Reason" />
<FieldRef Name="Year" />
<FieldRef Name="Start" />
<FieldRef Name="End" />
</ViewFields>
</RSSharePointList>
The start and end fields are date fields, and these return #error
. The other fields return the expected data in the query designer. The same is seen in the tablix when the report is run. I have no idea why this is happening nor how to get dates to return.