Hello everyone,
I am currently building a report on the HR Service Assignment Group (database view) to identify which assignment group is managing each HR service.
However, I am seeing what appear to be duplicate rows in the report. After reviewing the data, it seems that the duplicates are caused by multiple assignment rules pointing to the same group for a single HR service.
My goal is to display each HR service only once per assignment group for better readability.
Has anyone faced a similar situation?
What would be the best approach to avoid showing these duplicates in the report?
Any recommendations or best practices would be greatly appreciated.
Thank you!
