How would you generate this report?

2019-05-15 Thread MB Software Solutions, LLC
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, e

Re: How would you generate this report?

2019-05-15 Thread Kevin Cully
I've been creating my "reports" in HTML lately as a flexible, wicked fast way of producing output.  With CSS you have great control over looks and layout.  Images, no problem.  Links, no problem.  Content wrapping, no problem.  Page breaks, no problem. The only issue is full control over header

Re: How would you generate this report?

2019-05-15 Thread MB Software Solutions, LLC
Thanks for the 2 cents, Kevin! Still wanting to output these to Word documents though for end-user familiarity.  We email these documents to 100 organizations currently.  Better design would be some sort of integration into our website but that's Version .Next. On 5/15/2019 4:46 PM, Kevin C

Re: How would you generate this report?

2019-05-15 Thread Frank Cazabon
I do stuff like that using Bookmarks in a Word template and automating their replacement. Frank. Frank Cazabon On 15/05/2019 03:05 PM, MB Software Solutions, LLC wrote: Screenshot of Word document in question (with notations for where content is dynamic; some parts blurred just to protect the

Re: How would you generate this report?

2019-05-15 Thread MB Software Solutions, LLC
How do you dynamically add the rows?  Via Office Automation code?  If so, care to share? On 5/15/2019 4:54 PM, Frank Cazabon wrote: I do stuff like that using Bookmarks in a Word template and automating their replacement. Frank. Frank Cazabon On 15/05/2019 03:05 PM, MB Software Solutions,

Re: How would you generate this report?

2019-05-15 Thread Frank Cazabon
I'll have to look up the code but it's basically add a table with a row and columns and then add a row as needed. I may not get a chance to find it until tomorrow but Google should be able to give you the code On 15 May 2019 17:04:06 GMT-04:00, "MB Software Solutions, LLC" wrote: >How do you d

Re: How would you generate this report?

2019-05-15 Thread Frank Cazabon
LOCAL loWord AS WORD.APPLICATION LOCAL loDoc AS WORD.DOCUMENT loWord = CREATEOBJECT("Word.Application")     loWord.Documents.ADD(oAppInfo.GroupPlanTemplate)    &&("GroupPlan.dot")     m.loDoc = m.loWord.ActiveDocument *   Retrieve the number of bookmarks defined in DOC     m.lnCountMarks = m.lo