The query works fine in SSMS but fails to refresh and update the column names in SSRS !!
Just alias your column names !!! and remember not to select * !!!
Thursday, September 22, 2011
SSRS - An item with the same key has already been added
Ever got this message and wondered what does it means?
The query works fine in SSMS but fails to refresh and update the column names in SSRS !!
It happen to be that I've used the same column names in my query, but SQL handled it as I was using a table prefix in my join.
Just alias your column names !!! and remember not to select * !!!
The query works fine in SSMS but fails to refresh and update the column names in SSRS !!
Just alias your column names !!! and remember not to select * !!!
Subscribe to:
Post Comments (Atom)
Thanks a lot!!! I was just trying for almost 1/2 hour.....
ReplyDeleteThanks!!! It saved a lot of time....
ReplyDelete