Support

I thought "on the fly" reports was on the wish list, but I didn't find it, so I'll add my comment here.

A sample of the type of "on the fly" report I'd like to be able to save and run  . . .

We highlight on a map the states/provinces/countries where our members are located.  Right now it looks like I have to export to excel and then do a database sort to get a list of current countries and states/provinces.  Once I get it to excel, it is quick.  Would be so much nicer to be able to use the members database to show the current members, then select the country and state/province field to run a sort. 

Check out saved searches - they address at least part of your need.

 And one thing we plan to add (probably in 2.38) is ability to select which fields to display ('Custom layouts') - right now the selction of fields is hard-coded.

I may be missing something, but when I looked at using saved searches, I didn't see a way to pull out the "active" members and then sort them by country or state.  I know I can query on each country if I know what country to ask for - but if I don't know to ask, I miss it.  I can query for each state to see if there are any records.  But it involves over 50 separate searches, vs one search where I just order the data and see what is there. 

Saved search would work if I could then sort on various fields - kind of like data sort in excel

Saved searches only handle filtering now.

The new capability we plan to add is selecting which fields to output - and how to sort.

A workaround is to use a hidden member directory page - since it is already has field selection, filtering and sorting parameters.