Views

Re: Outputting Subset of 2007 InfoPath Form Data to 2007 MS Word

cbrown00 — Fri, 23 May 2008 17:13:23 GMT

Sorry.. not enough of a database programmer to understand your question.. I understand MS Excel well, (and now InfoPath form making!); some follow-up questions will help me with your questions:

You state:

"Are you pushing the infopath fields to sequel server?"

- How would this be accomplished in a non-enterprise, desktop computer-only environment? (e.g. Microsoft Access is only database tool)

- How would this be accomplished in an enterprise environment (e.g, using Syteline and Syteline modules for enterprise database support)

You state:

"You can link a Word doc to sequel and create a macro so everytime the specific word doc is open it pulls requested data"

- How does one go about linking a Word doc to a database app?

- How does one write a macro in Word? (I know how to do them in MS Excel; never have done that in MS Word; probably accomplished the same way)

Your answers will be tremendously helpful; this is a very important challenge to overcome for my team!

Thx

Re: Outputting Subset of 2007 InfoPath Form Data to 2007 MS Word

thoughtdream — Fri, 23 May 2008 16:51:17 GMT

Since your in office 2007 it's much simplier than 2003. Are you pushing the infopath fields to sequel server? You can link a Word doc to sequel and create a macro so everytime the specific word doc is open it pulls requested data.

Outputting Subset of 2007 InfoPath Form Data to 2007 MS Word

cbrown00 — Fri, 23 May 2008 15:07:23 GMT

I have managed to create a complex InfoPath form designed to help capture lots of project configuration information. It uses 10 buttons to navigate to that many different views when inputting the data into the form. Now that it is functional, I want to be able to have it work with 2007 MS Word-based so that target audience can access / use the information. Not all of the information collected in the form would be used for the outbound MS Word report, only subsets. Also, there are two different reports needed that have different issues. Specifically, I want to create the following two MS Word-based reports/docs:

Report #1

Probably coming from an InfoPath "view", this would be a formatted view of the subset of information I want to share from the form, but needs to be in MS Word form; would I create a print view and just copy or export it to MS Word?

Report #2:

I want to link the data in containers in the InfoPath form to target sites (fields?) in an MS Word template. How do I accomplish this?

I am not a programmer, but have managed to get this great InfoPath form operational. I've read on this forum about the SDK kit that does something to help with InfoPath-to-Word translation issues. Is that needed here? If so, is there a guide to get through that. It sounds somewhat complicated and having to deal with registry, etc. Thx