Solved
Help with searches...
i set up a report that lists each vendor and what states they checked off for service area, they are checkboxes, i don't know how to make it group all vendors that service alabama, all vendors that ...
np,
just make a formula field of type formula multi select.
use a syntax like this.
Formula Multi Select Text
Split(List(";",
If([Chocolate], "Chocolate"),
If([Vanilla], "Vanilla"),
If([Strawberry], "Strawberry")))Then include that field as a Dynamic Filter on the report configuration. It will offer up a drop down list of all your states.
