When executing this query, I am getting a message from SSRS that says "An error occurred during client rendering. An error has occurred during report processing. Query execution failed for dataset 'Tasks'. Unable to open the database file unable to open database file ":
<?xml version="1.0" encoding="utf-8"?>
<root xmlns="http://enesyssoftware.com/schemas">
<queryName></queryName>
<description></description>
<list title="Site Tasks" relativeSiteUrl="/tracker/" tableName="Site Tasks">
<fields>Title,Site_x0020_Lookup,Forecast_x0020_Date,Actual_x0020_Date,Task_x0020_Type,ID</fields>
<query>
<Where>
<Gt>
<FieldRef Name="ID" />
<Value Type="Counter">0</Value>
</Gt>
</Where>
<OrderBy>
<FieldRef Name="ID" />
</OrderBy>
</query>
</list>
<list title="Site Task Types" relativeSiteUrl="/tracker/" tableName="Site Task Types">
<fields>Title,Group,ID</fields>
<query>
<Where>
<Gt>
<FieldRef Name="ID" />
<Value Type="Counter">0</Value>
</Gt>
</Where>
</query>
</list>
<list title="Site Task Group" relativeSiteUrl="/tracker/" tableName="Site Task Group">
<fields>Title,ID</fields>
<query>
<Where>
<Gt>
<FieldRef Name="ID" />
<Value Type="Counter">0</Value>
</Gt>
</Where>
</query>
</list>
<sqlQuery tableName="Tasks">
<![CDATA[SELECT [Site Tasks].ID as ID,
[Site Tasks].Site_x0020_Lookup as [Site Lookup],
[Site Tasks].Site_x0020_LookupID as [Site LookupID],
[Site Tasks].Task_x0020_Type as [Task Type],
[Site Tasks].Task_x0020_TypeID as [Task TypeID],
[Site Tasks].Forecast_x0020_Date as [Forecast Date],
[Site Tasks].Actual_x0020_Date as [Actual Date],
[Site Task Group].Title as [Group Name]
FROM [Site Tasks]
INNER JOIN [Site Task Types] ON [Site Tasks].Task_x0020_TypeID = [Site Task Types].ID
LEFT OUTER JOIN [Site Task Group] ON [Site Task Types].GroupID = [Site Task Group].ID
ORDER BY ID]]>
</sqlQuery>
<resultSet>Tasks</resultSet>
</root>
The site tasks table has about 65000 records.