User Support Forum

Is there a report that can tell me who does not have a birthday on their profile?

dcc wrote:Is there a report that can tell me who does not have a birthday on their profile?

No .. you'll have to create a custom report to do that.

Thank you for your prompt reply. I never got the hang of custom reports, so if anyone has created one, please share.

1. Go to Membership > Personal Profiles > Other Output > Custom Reports.
2. Give the report a title like "missing birthdays".
3. When it starts the query builder:
   • STEP 1: Pick a Field, choose Birth Date
   • STEP 2: Is missing a date
4. Click Done.
5. Do you want to run this query now? Yes
6. Picking output fields: Click OK then double click the "Last Name, First Name" field.
7. Click Done.
8. Click Run Query.

Now you have made the custom report you need!

You are AWESOME!! One question though. Is there a way to print the report?

I realize I just didn't go far enough with the report and found where I can print it. Thank you so much! The custom report worked like a charm!