I am creating a custom form for the pastor to use when he goes out on visits. I am creating this report under personal profiles, custom reports. I am grouping by family, listing each member of the family along with their first visit date, or joined date. I'd also like to print out the notes that I have created in the main database, and in the individual database. The individual notes (menotes) are printing fine. The family notes (note1) are not printing at all.
I would also like to do an age calculation for the children based on their birthdates. Is this possible?
Thank you
Custom Reports note field not printing & need age
Moderators: Moderators, Tech Support
Re: Custom Reports note field not printing & need age
I went through the report setup once again, and realized my mistake. I was selecting the wrong note field. It is working now, just have to work on the alignment.
Still wondering about the age calculation.
Still wondering about the age calculation.
-
- Tech Support
- Posts: 3006
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Custom Reports note field not printing & need age
The following expression in a variable will properly calculate the age:
Hopefully, you don't need an explanation... I copied and pasted
Code: Select all
Year(date())-Year(born)-IIF(Month(DATE()) * 32 + Day(Date()) < Month(born) * 32 + Day(born), 1, 0)