User Support Forum

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

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.

The following expression in a variable will properly calculate the age:
Hopefully, you don't need an explanation... I copied and pasted