Monday, May 4, 2015

"An item with the same key has already been added" in SSRS report

"An item with the same key has already been added"

You may encounter this error while creating SSRS report and the reason behind this error is having fields with the same name in the query used in report. To deal with this issue, in AX go to the query used in report and identify the fields that are duplicated between the datasources in the query. Delete overlap field by setting the Dynamic property to NO at fields node of the datasource in query.

Happy Daxure!ing

2 comments:

  1. This is the information that I was looking for.. Thanks for the efforts you put to gather such a nice content and posted here.
    Microsoft Dynamics CRM Online Training | Microsoft Dynamics AX Training

    ReplyDelete
  2. I am facing this issue but there are no duplicate fields in the query !!

    ReplyDelete

I will appreciate your comments !

Download large bacpac (sandbox database) to DEV environment much faster

As the LCS website gets slower and slower and the database backups get bigger and bigger.  Use AZCopy to download objects out of LCS asset l...