Hi,

Last week I downloaded the evaluation version of Enesys RS Data Extension to create an SSRS report for a client of mine that has the full version. When I started development everything was working fine, and I created a report for them. A few days later when I went back to make modifications to the report I tried to run the report and received the following error (it's pretty long so I only copied the first part of it):

"TITLE: Microsoft Report Designer
------------------------------

Could not generate a list of fields for the query.
Check the query syntax, or click Refresh Fields on the query toolbar.

------------------------------
ADDITIONAL INFORMATION:

 No Project List starting from /headcount/tr/  and including the following subsites :
 <DocumentElement>
  <_x002F_>
    <SiteTitle>Office Canvas Workflow Center</SiteTitle>
    <Url>http://neu-off-dev</Url>
    <RelativeSiteUrl>/</RelativeSiteUrl>
    <RootWebUrl>/</RootWebUrl>
  </_x002F_>
  ..."

Here's the query I'm running:

<?xml version="1.0" encoding="utf-8"?>
<root xmlns="http://enesyssoftware.com/schemas">
  <queryName></queryName>
  <description></description>
  <rollUpLists title="Project" relativeSiteUrl="/" tableName="Project">
    <fields>*</fields>
    <query></query>
  </rollUpLists>
  <resultSet>Project</resultSet>
</root>

Any idea what's going on?

Hi Marien,

The account I'm using is a SharePoint admin account, and I've verified that it has access to the Project list. 

To answer your questions:

1. Yes, I'm using an SPLogin on the BIDS environment (the login I just mentioned)

2.  The thing that's got me confused is that this query runs just fine in Query Builder, but then when I move it to BIDS, it stops working, even though I'm using the same login account, connection string, and query.

Thanks for the help.