I have a SQL Server 2008 configured with SQL Server Reporting Services 2008. I created a datasource and I'm trying to generate a model for it. I get the following two error messages:More than one item in the Entity "Table Name" has the name "Column Name". Item names must be unique among immediate siblings. (DuplicateItemName)More than one Field in the Entity "Table Name" has the name "Column Name". Field names must be unique within an Entity. (DuplicateFieldName)Although I don't (and can't have two columns with the same name in a table). The columns that exist are like ColumnName and ColumnNameKey and SSRS is somehow not able to differentiate this. Any idea how I can fix this without deleting or renaming my column names?Much appreciated!-Anand

Hi Anand,Could you provide more details so that we can repro your issue in my test? Once i reproduce it, i will give you a feedback asap.thanks,Jerry

Hi, I don't know if this is the situation you have but we had the same error when we had a foreign key with a primary table that has the same name as a column on the foreign key table Ex. Two tables, Employee and Number Employee table has the following columns: Name EmpNumber (FK to table 'Number') Number. In SQL database, there is no problem as all columns are unique on the Employee table. When building a Report Model, the generator will try to create two entities on Employee, a item called Number (referring to the linked table) and a Field called Number. Boom! You can't have to items with same name.

Terrible :)