Custom Reports note field not printing & need age

Moderators: Moderators, Tech Support

Post Reply
Dicounts
Posts: 3
Joined: Mon Jan 21, 2008 4:02 pm

Custom Reports note field not printing & need age

Post by Dicounts »

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

Dicounts
Posts: 3
Joined: Mon Jan 21, 2008 4:02 pm

Re: Custom Reports note field not printing & need age

Post by Dicounts »

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.

Zorak
Tech Support
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

Post by Zorak »

The following expression in a variable will properly calculate the age:

Code: Select all

Year(date())-Year(born)-IIF(Month(DATE()) * 32 + Day(Date()) < Month(born) * 32 + Day(born), 1, 0)
Hopefully, you don't need an explanation... I copied and pasted :wink:

Post Reply