How would you generate this report?

Author: MB Software Solutions, LLC

Posted: 2019-05-15 at 14:05:25

Screenshot of Word document in question (with notations for where

content is dynamic; some parts blurred just to protect the players): 

https://www.screencast.com/t/vOJd9eBwPaX

Currently, my colleague did so many of these documents MANUALLY in

Word.  I'd pull my hair out if I had to do that, especially since I've

got VFP.  The trick here is to dynamically enter the names for each

letter to an organization.  Each organization can have 1:M names in this

report.

The quick thought is a VFP FRX Report, using XFRX (or something else) to

save the output to a Word document.  And given that the text above the

dynamic organization name and user names/emails part is static, I could

do it.  But like you've probably encountered before, I don't like to

force the Line-breaks in the VFP Report Writer if I can avoid it (PITA).

So how would you produce these dynamic Word documents easily?

Flattened cursor for this would have this structure:

* OrgName

* OrgID (e.g., P0135)

* Name

* Email

* AcctType

That's it.  User would select the Yes/No values and return to us.  Task

here is generated these 100 reports without having to manually do it

(and obviously avoid the human error factor).

tia,

--Mike

---

This email has been checked for viruses by Avast antivirus software.

https://www.avast.com/antivirus

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: https://leafe.com/archives

This message: https://leafe.com/archives/byMID/5e9413df-b3db-21ed-3392-848e4bf27cce@mbsoftwaresolutions.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2019 MB Software Solutions, LLC