Notifications
Announcements
No record found.
Hi Experts,
I've been having an issue where I keep getting the error "an item with the same key has already been added" when I try to add a query with HCMWorker Table as datasource in my dataset for a SSRS report.
I've looked up this error online and people were saying it is due to duplicate fields generated by the query, but there are no duplicate fields in the query. Can any one help me out to solve this issue please.
Hi Sir,
How about your "Dynamics Fields" property in your Query?
Hi Blue Wang,
Thanks for your response. It keeps giving me error with both YES or NO as dynamic fields property.
I found that the issue occurs when I add the field person in the query, noting that the table used in the query is HCMWorker and the dynamic fields property set as No. I am able to add other fields except Person in the query but facing the same error when joining other data sources in the same query.
any workarounds ?
I am using a data provider class and a temp table so there is no way the column name can be duplicated. but still I am getting the same error.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 451 Most Valuable Professional
André Arnaud de Cal... 428 Super User 2025 Season 2
BillurSamdancioglu 239 Most Valuable Professional
