Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I merge memos & show at bottom of report
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00622860
Message ID:
00623021
Views:
15
Doug,

That's exactly what I did on a report last week only I used a field in a table instead of a variable, but you can use a variable. Notice that I also checked to see if the memo field was empty before adding it and I also added chr(13)s to put spaces between my notes for readability. And I added the person's ID and name to the note along with a time stamp.

Here's my coding sample -
IF ALLT(notes)>""
 REPLACE observe.comment with "--- At: "+dtoc(datetime())+" "+time()+;
 " By: "+mcoid+" "+mconame+" --------------------- "+chr(13)+alltrim(notes)+;
 chr(13)+ chr(13)+observe.comment
ENDIF
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform