Saving Datawindow content as word document

Yehuda

unread,

Jul 5, 2005, 3:00:19 AM7/5/05

to

Hello dear friend and colleagues.

I have an application in which we send the company's
customers letters which are designed as Datawindow (the
letter retrieves information from the DB). Most of the time
the DW is being printed and sent by mail.
Some of the letters need a little modifications made by the
users. They want to do it in MS Word. How can I save the
content and design of the DW as a Word Document?

Any Help will be appriciated!

PascalB (Search4)

unread,

Jul 5, 2005, 3:14:35 AM7/5/05

to

Hi Yehuda,

We managed to do this by printing to pdf-file and using a pdf to doc
convertor.
Directly from PB to Word was tricky and not so easy to do.

Using:
- Amyuni pdf printer for making the pdf file
- www.solidpdf.com for the third party convertion tool pdf to doc

These are the best solution for our case.

Hope it helps you on your way.

Greets,
Pascal B

<Yehuda> wrote in message news:42ca2fff.5b9...@sybase.com...

Yehuda

unread,

Jul 5, 2005, 3:47:15 AM7/5/05

to

Thank you very much Pascal for your answer.
I will have to check if my organization would like to
purchase the doc converter tool.
However, can you specify the tricky way to convert directly
from PB to Word?

Thank you for your help.

Yehuda

PascalB (Search4)

unread,

Jul 5, 2005, 7:57:33 AM7/5/05

to

Now that's another story.

You should work with an template for every datawindow you want to make in
Word.
Connection thru OLE and you'll have to fill in every field by script.
So there are no advantages, only more problems.

The convertion tool is not so expensive and easy to use.

Take the time you'll need to make your templates and scripts at proximatly
100$/hour.
(And God knows how many hours it will take...)
While this tool only cost half the price of an hour work.

Other advantages:
- No more templates for a new report (datawindow)
- No scripts to maintain for filling in the values

If you find an other solution, please post it, so I can review my opinion on
this.

Greets,
Pascal B

<Yehuda> wrote in message news:42ca3b03.4e9...@sybase.com...

SharonG

unread,

Jul 8, 2005, 12:01:49 PM7/8/05

to

I have used the OLE connection successfully. Set up a word
template - bookmark the fields you want to take from the
database. Use
ole_object.selection.goto(true,0,0,"name")
ole_object.selection.typetext(mpname)

to find the bookmark then place your text.

You can print and/or save the word.

Good Luck,
Sharon

Yehuda

unread,

Jul 11, 2005, 1:28:32 AM7/11/05

to

Thank you very much Sharon.
I will try your solution.

Yehuda

PascalB (Search4)

unread,

Jul 11, 2005, 3:16:29 AM7/11/05

to

Hi,

This solution really works, but what about nested reports?
For nested reports, you'll need seperate templates and then merge them all
in 1 document.

For every dw you'll need a new template + script, so you will have more
script to maintain.
Also the document layout may not be the same as this from the report in PB.

But as long as it works, we are all happy ;o)

Greets,
Pascal B.

<SharonG> wrote in message news:42cea36d.732...@sybase.com...

Yehuda

unread,

Jul 11, 2005, 7:46:20 AM7/11/05

to

I know that it is a problem.
Unfortunatly, I don't have much choice since the converter
you suggested (the Demo version) has problems with Hebrew.
My document is converted to Gibrish...

Thanks again,
Yehuda

PascalB (Search4)

unread,

Jul 11, 2005, 9:07:57 AM7/11/05

to

I'm only pointing out possible problems that I also encountered by
converting thru OLE.
And the nested reports was one of the tricky parts... :o)

Hebrew, Gibrish... I only needed Dutch, French and English convertion.

Anyway, I hope you're on way to the final result.

Greets,
Pascal B

<Yehuda> wrote in message news:42d25c0c.2a2...@sybase.com...