hello , i am trying to create a report model i get these errors Entity has no fields for a table where all columns are part of primary key. and for the same table i get saying no identifyingattributes. Can you please suggest what is wrong here.. Thanks Madhavi

Well i guess, the columns you are selecting in Model all are part of PK. you might want to select one more column which is outside the PK and see if it works, I suppose if you select all the PK fields, SSRS has no data to aggrgate pls just give it a try... Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

i want to select other columns.. but the table has only those columns no columns outside the primary key .

Hi, Try to write a query to generate an new ID as PK, for example, row_number() function, then on the view diagram surface, only set the ID as logical primary key, so other columns will be available for being selected. thanks, Jerry