I was just thinking how helpful it would be if we could create runtime parameters inside of a report. What I'm thinking is something like this WHERE biblio.title LIKE CONCAT("%", <<Title contains one of these words|["good", "box", "friend"]>>, "%") creating a drop-down that has the three options: free, good, box. Being able to create parameters would open up a lot of new options with writing reports.
+1
Maybe a variation of this would be something like: WHERE biblio.title LIKE CONCAT("%", <<Choose one|["Coeur d'Alene Library|COEUR", "Liberty Lake Library|LIBLAKE", "Post Falls Library|POSTFALLS"]>>, "%") This iteration would allow you to define what the options look like in runtime, and what value is actually being used.
+1 - I'd love to see this functionality added to Koha.