"An item with the same key has already been added."
Based on some quick googling, it looks like there are several potential causes for the error, but here's why I received it today.
The stored procedure I had declared as the query source had the same column name declared twice. Even if you use different data from different tables, even if you declare them differently, SSRS needs all column names in the final dataset to be unique.
That error message isn't helpful, but that was the solution for me, for what was a clumsy mistake to begin with.select tablea.samecolumnname ,tableb.samecolumnname ,samecolumnname = tablec.columnname ,tabled.columnname as samecolumnname ...
1 comment:
thanks! 3 years later I ran into the same problem and your solution was just what I needed.
Post a Comment