2
I have a huge report to put together, made up of over 1,000 smaller, nearly-identical reports.
Each report includes:
- General 1:1 information (basic mail-merge stuff)
- Lots of text, some of which may need to be disabled or have alternate text based on a boolean field.
- A few embedded images, preferably loaded via HTTP URL, but if they have to be on the a file system thing I can do that. (Filenames will be provided as a field in the data source.) Fortunately, all images are roughly the same size/shape.
- Several 1:m tables with a few fields apiece.
The kicker is the master/child tables. I've seen examples for Word 2000 for doing this by left-joining the master and child table and using some IF/THEN logic to know whether to jump to the next master record. But in my case, I have several of these subtables, so that approach won't really work.
So, can Word 2003 handle arbitrary master/child tables? If so, how?
If not, I considered InfoPath, but I haven't used it before, and it seems to be made for data entry, not long formatted reports.
I'm a software developer, so I could always hack something together with a massive VBA macro, or generating the report in HTML on the web server (where the data is coming from anyway). But I'm hoping Word will work without such gymnastics, since it will give the ultimate users of the report template better control over formatting and making minor changes.
richardtallent
Posted 2010-10-18T18:30:06.963
Reputation: 1 052
Word... left-join... logic... Ok, i'm outta here. Is this a case of "wrong tool for the job"? Well, it seems like you are locked in on MS Office, but still... Sorry, can't help you. – lajuette – 2010-10-18T19:11:42.447
Did you ever come up with an answer to this? I am hoping to be able to reference two tables in letters using mail merge (one with vendor information, one with client), but so far am at a loss. I have been banging my head against making Excel more flexible, and it isn't working. – mfg – 2011-04-21T15:07:45.780