Skip to main content What is Dynamics 365? Guided tours Customer stories Try our products Build your own agents CRM ERP Sales Service Sales Customer Insights Customer Service Contact Center Field Service Supply Chain Management Commerce Finance Project Operations Human Resources Business Central Pricing Business application topics Training & certifications Migrate to the cloud Documentation Events Dynamics 365 Blog Product updates Onboarding and implementation Community Find a partner Software Development Companies Partner resources Microsoft Marketplace Product documentation Technical support On-premises product support Contact us Try for free Sign in
  • 1 min read

Getting message “An item with the same key has already been added” when creating an SSRS report


This error is caused by having fields with the same name in the query the report is built upon.  To rectify the issue, in AX go to the query you created and identify the fields that are duplicated between the datasources in the query.  On the Fields node of each data source set the Dynamic property to No.  Changing this property will allow you to remove fields from the query.  Then delete the fields that overlap.

Get started with Dynamics 365

Drive more efficiency, reduce costs, and create a hyperconnected business that links people, data, and processes across your organization—enabling every team to quickly adapt and innovate.