I plan to create a survey that is taken at an on-line web page and that stores the results into an Access database. The answers are primarily drop-down, numeric or strings. The results are meant to populate a 30 page template document, thus so that I get a Office Word or Adobe PDF document back?
The survey --> backend --> document is basically a glorified mail merge. The limitations of a mail merge (being restricted to one data source, no objects) leave the project wanting in these two main areas:
The engine would need to deal with having a variable carrying a value of
[x|y|z], and to have the engine render different, but pre-defined paragraphs.
In some cases there are branching survey variables where
if A = 1 -> ask B,C,D(include more text for each in document);
if A = 0 -> jump to E(omit text for
The engine would need to know to not render a paragraph in such a way that it is cut off between pages, render headers/footers, etc (less necessary, as can be added by hand)
The questions that I have are:
What is involved in creating some kind of engine that can do this?
How do I better explain what I am looking for, in terms of an engine and a process?
Is there a particular language or piece of software that excels at this type of purpose?