I'm creating custom reports for a school that should compile a list of students who have opted not to have their directory information shared. I would like to filter it by campus so that each campus has their own report that only displays their students, but since that field is a drop-down that gets populated off of a lookup there aren't any available values to select in the filter, and it won't let me manually type what value by which to filter.
I know I could change the drop-down to a single line field, or add a hidden single line field that gets autofilled with the value of the drop-down and use that to filter, but that's a lot of modification to a lot of similar forms; it would be great to be able to just manually type a value to look for in the drop-down.