Reporting on Basic List Selection?
Got a question here on the back of a request from a fellow analyst. They want to force users raising calls via a particular offering to select a category from a specific list of say 20 categories, in order to better filter and report on this particular set of helpdesk requests efficiently later.
What I'm wondering is, is there a simple way to do this, or am I going to need to create an actual new 'Property' field for the offering. My initial thought is "Oh, I can just create a custom dropdown list in this offering and the user can select the category from this list" which will take 2 minutes to do. But I don't know that this can then be reported on easily?
So there are two parts to this question post I guess.
1 - Is there an easy way of reporting based on basic dropdown list fields created for an offering? Is this data stored somewhere in a readable format? I ran a SQL search on the server but not much came up.
2 - If a basic list is not going to be good enough for reporting, is creating an entirely new Property the best option? Nothing else really viable?