I have read several threads regarding this error but have not found one similar to what I am experiencing. I am creating several reports for an application and therefore copy/paste (using a telerik prescribed method). I was able to do this for one report, make some modifications and quickly create a new report that has the same style as the original. I went to add the third and on this one I got this error.
At first I thought there was an issue with duplicate field names, etc. However, this didn't really make sense as their definitions are "private". After deleting fields, etc and getting no where, I ended determining the the issue is related to the sql query string. When I go to configure the datasource using the wizard, I enter the query string and when I attempt to click "Execute Query" this error display. In this query I am selecting similar column names from the database. I renamed the datasource name property and still no luck. Why would my query cause this? I have listed them below. BTW... both queries execute fine in SQL Server Management Studio.
See attachment.
sqlDataSource1
SELECT Groups.*, Softrip.dbo.Suppliers.SupplierName
FROM Groups LEFT OUTER JOIN Softrip.dbo.Suppliers ON
Groups.SupplierID = Softrip.dbo.Suppliers.SupplierID
sqlDataSource4
SELECT StatusChange.*, Groups.*, Softrip.dbo.Suppliers.SupplierName
FROM StatusChange LEFT OUTER JOIN Groups ON
StatusChange.GroupID = Groups.GroupID LEFT OUTER JOIN Softrip.dbo.Suppliers ON
Groups.SupplierID = Softrip.dbo.Suppliers.SupplierID