Interesting Issue in Activities & Skills

[NeilZ]

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.

[BrianShoe]

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