Polished letters with Data Displayed

[alr0]

Hi All,

I need to produce professional looking merged letters that are driven by and display SQL Server data. Some of this is simply conditional formatting but the more complex part is displaying certain records in a one-to-many table that are flagged with a descriptive paragraph.

Access reports are great but they are not for formatting business letters.

Word works for the formatting and conditional printing like, if MyField=0 do nothing, if MyField=1 print the paragraph. It is difficult to display the many side data in anything but a table and connecting to more than one table is very tedious.

This is a growing part of our work that I would like to do with finer control and make some templates that less skilled employees could handle under many circumstances.

Anyone know of any products, tools, techniques that would at least be a move in the right direction.

Thanks,

alr

_____________________________________
There is no rule more invariable than that we are paid for our suspicions by finding out what we expected.

Henry David Thoreau

 

[onpnt]

This is not the right forum to ask on what things you should implement to fix your business reporting issues but you may want to look into SSRS (SQL Server Reporting Services)

I'm not really understanding what type of "letter", umm reports? you want though.

There is a forum on this topic

forum1462

_{____________ signature below ______________
You may get help by means of code here. Just recall what happens to a rat when he eats the cheese off a rat trap while you're Ctrl+C/Ctrl+V'ing that code as your own}