User Support Forum

I just realized that the church officer skill list is not available in custom reports. I wanted to pull a comma-delimited report so our nominating committee could pull the data into a spreadsheet or Access database.

No can do ....! Its probably been this way the whole time, but I've never noticed it until now. I take it that the officer list is in a separate database table. If so, perhaps access to that table could be added to the Activity and Skills custom report module ??

Thanks.

Apparently Neil's observation still holds in ver. 9!!

I'm trying to set up a custom report to output current officers, or previous officers given the date range. I find absolutely no access to the fields in the officers table (SKSERV) when I check available fields in the Custom Report generator.

Has anyone managed to create any kind of custom report that looks up officers?

Failing that, has anyone created a SQL query (in the Database Manager) that retrieves officer data from SKSERV, but then does the necessary lookups in ME (lastname, firstname) and SKREF (Desc given the skill code) ? I'm finding that SQL in Visual Foxpro doesn't work quite the way it does in Oracle - apparently can't use aliases.

“There is only one corner of the universe you can be certain of improving, and that’s your own self.”
- Aldous Huxley