Interview Question in SQL Server Reporting Services (SSRS)


 

Interview Question :: I am getting an error message while trying to configure SQL Reporting Services. Why


I connected to the database fine, but when I generate the model for the database, it gives me the following error message.
More than one item in the Entity 'PR' has the name 'X Charge Wks'. Item names must be unique among immediate siblings. (DuplicateItemName) Get Online Help

More than one Field in the Entity 'PR' has the name 'X Charge Wks'. Field names must be unique within an Entity. (DuplicateFieldName) Get Online Help
Answers to "I am getting an error message while trying to configure SQL Reporting Services. Why"
RE: I am getting an error message while trying to configure SQL Reporting Services. Why?

sounds like your data model consists of a duplicate data value within a table in a column that has a unique index (like a primary key field)
 
Vote for this answer ::  
Update Alert Setting