Merging data from PB with a OpenOffice Template

dhruv_chhajed · Newbie Joined: 05 Mar 2003 Posts: 3 Location: India

I was wondering if you have some ideas of how I would do the following.

I have...
1. A PB application which contains a data window with multiple rows of data.
2. A Word template that has template fields that match the data fields on
the data window.

I want to..
1. Take records from my data window, one by one, and merge with this
OpenOffice Template.
2. User is able to modification in template and template fields.

i am working with PB 7.0 and MS Sqlserver 7.0

How would I accomplish this.
Dhurv

draude · Posted: Thu Mar 06, 2003 1:06 pm Post subject:

Isn't this standard mail merge (form letter) functionality or am I missing something?

Have you tried to setup SQL server as a data source in your OOo template? You don't need to have PowerBuilder come between OOo and the actual data source.

Guest · Posted: Thu Mar 06, 2003 2:41 pm Post subject:

Try this to see if I understand what you want to do.

Open a new Writer document and press F4 to show your registered databases. Open up the Bibliograghy database until you can click on the biblio table. The data will appear to the right.

Drag & drop a few field names (not actual data) into the document. Click the gray box to the left of one of the records so the record is highlighted. Then click the Data to Fields icon, which is next to the envelopes. The data should replace the field names.

If this is what you want then you simply need to set up your database as a data source and you're on your way. You will most likely have to read the help to get your database registered but I managed so it can't be too hard.

JohnV