July 7, 2006 at 2:26 pm
I know it is not an option to export to Word in the picklist, but I wonder if anyone has a way to do this anyway. I tried exporting to HTML and then opening that in Word, which actually looked pretty good, only Word automatically inserted a header (with the report title) and a footer (with the filename and path) onto the page which forced a one-page report onto two pages.
July 7, 2006 at 3:40 pm
If you are using SQL2000 there are stored procedures that let you use ActiveX controls.
sp_oaCreate etc.
You can instantiate a copy of word then call methods from the Word object model.
I played with this ages ago but rejected it because the thought of sticking MS Office on a production server gave the infrastructure guys the screaming heebie jeebies.
July 11, 2006 at 6:38 pm
Thanks for getting back to me - I've been swamped and haven't had time to investigate this further, but I will post again when I have more.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply