Custom (Tally) Reports

[ssbarsky]

I like "Tallies by class" but since I'm using "master import" for basic database entry, the useful in formation gets munged.

86 | Earned Volunteer Membership for Next Boskone
  | Comp gifted from Life Member Volunteer
128 | Adult PreRegistration Rate
5 | Young Adult (ages 18-25) PreRegistration Rate
5 | Child (ages 5-17) PreRegistration Rate
  | Void
  | Report COAs for nonmembers
  | Virtual attendee, comped
  | Program Participant, auth by Pgm Ops
115 | Life Members
  | Rollover membership
7 | Carryover membership
5 | Guest of Honor (at current convention)
  | Comp. Membership, auth by Chair only
174 | Former GoH
2 | Other designated guests
  | Rolled over to NEXT Boskone
  | Adult, full weekend
1 | Adult, full weekend w/coupon
6676 | master import
  | Discovered after the con
  | YA 18-25 full wkend
2 | Kid-in-Tow (with parent)
  | Press: print, electronic, or otherwise
  | Stuffed animals, etc.
  | Printers, copy machines, stage props,&c
  | Working (service) animals
  | Child 5-17 full wkend(with ID or parent)
50 | Adult Year Ahead Rate
  | Young Adult Year Ahead Rate
  | Child Year Ahead Rate
  | Adult Friday only
  | Adult Saturday
  | Adult Sunday only
  | Adult Friday & Saturday
  | Adult Friday & Sunday
  | Adult Saturday & Sunday
  | YA 18-25 Friday only
  | YA 18-25 Saturday only
  | YA 18-25 Sunday only
  | YA 18-25 Friday & Saturday
  | YA 18-25 Friday &  Sunday
  | YA 18-25 Saturday & Sunday
  | Child 5-17 Fri
  | Child 5-17 Sat
  | Child 5-17 Sunday only
  | Child 5-17 Fri & Sat
  | Child 5-17 Fri & Sun
  | Child 5-17 Sat & Sun
  | Adult aide to a member
4 | Dealer Membership
  | Staff � worker rate
8 | Virtual attendee
1 | Do not register! Call for help!
  | We need to collect money from these folk
  | Active military; check ID
  | 16-Feb-2022 19:43 EST

203 | Paid class
7066 | Free class
0 | Bad class
7269 | Grand total
0 | Transferred
1 | Void

(I got Ctrl-C to work!)

I'd like to be able to suppress classes with no members, as well as classes that I don't want to see in the report (master import, void, do not register)

I haven't tried using List but I don't want to list ~600 members (yet, I might for at-con reg people). How complicated would it be to add my own report criteria, or get an addon to the software?

[ssbarsky]

P.S. this is data through 12/28 not counting Program Participants (that aren't Life or FGoH members.)

[jordanbrown0]

Report List will let you set a custom filter. Not that the filter UI is great, or as powerful as one might like, but there's something. It would also be good if you could save a filter for future use.

Perhaps "ignore classes with no members" should be an option for tally-by-class.

[ssbarsky]

Doesn't List just displays basic member info? Or is there a way to get the summaries that I'm missing?

[jordanbrown0]

Report List is just a list, not a summary. But you commented on it.

Hmm. Maybe a general-purpose tally-by report, with saved configurations.