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.