Printed 2017/08/20 05:32PM

#SSRS error – An item with the same key has already been added

By Samuel Vanga, 2011/11/10

Here is a simple yet annoying error I ran into while creating a dataset. Below is the query that I was using and it would run just fine when executed from management studio.

CalendarYear Yr
, CalendarMonthNum Mth
, CalendarMonthName Mth
dbo.Orders o

But SSRS doesn’t like those two columns with the same name “Mth” resulting in the error “an item with the same key has already been added”.
To resolve this simply make sure that no two columns in your dataset have the same name.


Copyright © 2002-2017 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.