Custom report with 'memo' result

Postby Lynn » Mon Sep 03, 2018 12:12 pm

Hi, I am trying to get a custom report from Activities that includes Allergies but when I export it the field just states 'memo' instead of the actual data.
Also, I would like the Notes field from Personal Profile/Notes&Codes to be an export field - is that possible?
Lynn
 
Posts: 7
Joined: Wed Jul 08, 2015 4:18 pm

Re: Custom report with 'memo' result

Postby NeilZ » Mon Sep 03, 2018 3:52 pm

Lynn wrote:Hi, I am trying to get a custom report from Activities that includes Allergies but when I export it the field just states 'memo' instead of the actual data.
Also, I would like the Notes field from Personal Profile/Notes&Codes to be an export field - is that possible?


Are you using Powerchurch custom reports, as you say you're 'exporting' the field. If you select the field as part of the report it will appear in any printed report, and should appear in any exported text files.

As far as the notes field, it is available as Profile Notes.

Neil Zampella

Using PC+ since 1999.
NeilZ
 
Posts: 8904
Joined: Wed Oct 08, 2003 12:20 am
Location: Connellsville, PA

Re: Custom report with 'memo' result

Postby Zorak » Tue Sep 04, 2018 8:14 am

The unlimited notes fields (memo fields in the database) can be included in printed reports, but aren't able to be included in file exports. That goes for files created from under Export Data or in Custom Reports. Unfortunately, it is a limitation that we don't have any control over. The Export to Access utility is the only way to get that info exported into a file.
Zorak
Tech Support
Tech Support
 
Posts: 2490
Joined: Thu May 13, 2004 8:59 am
Location: PowerChurch Software