1 Reply Latest reply on Feb 14, 2020 11:05 AM by Cris Coffey

    Is there a report to show who a category is assigned to?

    Janna Horn
      Share This:

      I have been asked for a report on who the categories are assigned to, I tried to modify the default report but don't see the option for the assigned to...

       

        • 1. Re: Is there a report to show who a category is assigned to?
          Cris Coffey

          Since there can be multiple specialists per category, that type of relationship likely means another table is used to store the relationships so getting a report out of that is not going to be possible using this Category report because that supporting table cannot be added to the data source. This would likely require some research in the ERD and/or assistance from support and R&D as well to identify where that is stored and how the relationship is mapped, as well as an external method of showing that either in something like a SQL Reporting Services report or a custom View. I could be wrong and will wait to see what others recommend but based on what I am seeing by looking at it, that is what I believe to be the case.