Need help with custom Church Directory

[diaperbunny]

Hi all,

Our church is using Powerchurch 8.5 on Windows XP and we followed the guidelines on Powerchurch website to create a custom Church Directory. Yet we are having two issues that we could use some help on.
Here they are.

1) How do we add the children to a custom directory
2) Is ti possible to do the headers of A B C to break up the last names in Identifying them. The main reason we could not use the Church Column Directory report was do to Small numbers (Eldery could not see). So We built our own yet we do really like the headers identifying the Starting letter of the last name...

Thank you for your repsonse...

[Zada]

There is a way to add the A, B, C grouping. This variable would be entered into the data grouping area of the custom report:

upper(substr( lastname_a,1,1))

For the kids to show up you can add a variable like this called m.kids:

IIF(PERS_NO > 2, IIF(NOT EMPTY(M.KIDS), M.KIDS + ", ", "") + ALLTRIM(FIRSTNAME_B) + IIF(LASTNAME_A <> LASTNAME_B, + " " + ALLTRIM(LASTNAME_B), ""), M.KIDS)

Remember that when you use a variable like m.kids that alot of things come into play like how you're grouping the information, where m.kids is placed on the report, etc... So you may want to take a look at the chapter on custom reports in the manual or contact our custom reports department.

Hope this helps!
Zada