custom officer reports

[apgoogh]

I see in previous versions to 10.4, custom reports were not possible on officers (current or past). In 10.4 I cannot figure how to do this. Has this been made possible?

apgoogh

[Zorak]

It looks like this is still not possible even in Version 11.1.

The Access export would allow you to do that, but the built-in custom report writer has never allowed you to report on offices served.

[DonHD]

Re reports on Offices Served tabla SKSERV
Its hard to understand how a need raised by BrianShoe in 2004 and 2005 is still unmet many revs later. You only really need to allow an entry point to run a query that joins tables....then we can export at will!

Both formatted reports ONLY report on current Members, while the one on former officers clearly should be relieved of that restriction

[Zorak]

Version 11.1 added an Export To Access utility, so you can do all the reporting and querying that PowerChurch Plus doesn't offer directly.

[Eden Whitehead]

Version 11.1 added an Export To Access utility, so you can do all the reporting and querying that PowerChurch Plus doesn't offer directly.

Does this presuppose that one has access to Access? What if Access is not an available?

[Zorak]

This was added in response to a lot of requests from existing users that apparently do have Access. We saw it also as a solution to those with requests like DonHD's, who want to do direct data queries with more complexity than the Custom Report Writer allows.

Obviously, if you don't have Access or have it and don't know how to use it, then this will not be much of a benefit to you. Open Office is a free alternative to Microsoft Office that will open Access files.

http://www.openoffice.org

[Eden Whitehead]

Open Office is a free alternative to Microsoft Office that will open Access files.

http://www.openoffice.org

Thank you for this pointer!

Eden

[DonHD]

Ok, I waited till our office admin went home and exported the Membership and Skills stuff to an Access MDB. After the export I needed to input the relationships between ME, SKSERV, SKREF and SKCODES. Before I spent time polishing my query, I went back and imagined it was days later and time for updated information. The reexport demolished everything I did for relationships and query design. How practical is this "solution" for something a non-programmer is to run on occasion? Is there a way to stash this "development" work somewhere where it is easy to get it back? I am admittedly a newbie to Access.

[NeilZ]

Just a question ... why would you need to have information on former officers who are not members any longer ??

[DonHD]

In many cases here, former officers and committee leaders are no longer active members but are friends or ex-members still in the community. In addition I am interested in the proximity of their serving in (the stressful) president's position and their resignation dates. A report in committee/role order would show the arc of leadership in that committee/role. In any event, it seems most of the canned reports have way too much white space and sprawl for pages for an IT long-timer like me.

[NeilZ]

Well Don,

these aren't printed on green line, tractor feed paper printers either ...