I'm trying to run a contact report which sorts by Street Name, but it's not available as a sort option, and the list of options available seem abitrary and vary depending on the base report I use.
Strangely enough, Street Number is available as a sort option, which is definitely useful, but not so useful without Street Name. Some of the custom fields that I've created are also visible, but not all of them.
Things I've tried:
- Checking to make sure address parsing is turned on (it is, and the street_name column is populated in the database with valid data)
- Adding the street name column to the report to make it viewable
- Trying an assortment of different contact reports as the base report to start from
I'm not sure where to go from here and am really not happy with how convoluted civireport is. I'm on the verge of starting to look into third party mysql reporting tools to accomplish this and would rather not if I could avoid it.
Does anyone have any suggestions? What determines whether or not a column appears in the sorting tab?