Hi,
Just to be sure, I have created a lookup field called "Property" and reported over without any problem.
Could you let me know the exact version of Enesys RS Data Extension you are using? A report called "Query - Version information" is included with the samples. By running this report you can get version information. Alternatively, you can create a report yourself using the following query:
<?xml version="1.0" encoding="utf-8" ?>
<root>
<version></version>
</root>
Just be aware that when running this query from the designer you will only get version information for the data extension installed along the report designer and not the report server. You would need to deploy a report with some layout that uses this query for retrieving version information about the data extension installed on the server. Anyway, if you get the error while running the report in the report designer, providing version information for the report designer's installed data extension will be sufficient.
Would it be possible to send me your list containing property values saved as a list template including the content. Depending on language used, site or list customization, list templates do not always import well. If you could send it to me as an exported excel file as well, it would be great. I will create a "Property" field that links into this list (let me know which field your are looking up) and will try all possible values.
In case, I can't get to find the problem using this approach, could you see if there would be any possibility to connect through vpn to your SharePoint site for debugging purpose. Of course, depending on your policy, I would be glad to sign a NDA. You would only give me limited temporary access to the specific lists involved in the query.
You may also be interested in using some filter in order to see if the problem may be caused by some specific Property value. Using the following query, you may just retrieve a specific item and see if you still get an error:
<?xml version="1.0" encoding="utf-8"?>
<root xmlns="http://enesyssoftware.com/schemas">
<list title="Property Financials" relativeSiteUrl="/" tableName="PropertyFinancialList" useDisplayName="false">
<fields>Title,Description,Property,Account,Date,AmtBilled,AmtRcvd,AmtCTBilled,AmtCTRcvd</fields>
<query>
<Where>
<Eq>
<FieldRef Name="Title" />
<Value Type="Text">Some_Existing_Title</Value>
</Eq>
</Where>
</query>
</list>
<resultSet>PropertyFinancialList</resultSet>
</root>
Best regards,