[geeks] open office writer and database merge

[Patrick Giagnocavo]

Francois Dion wrote:
> On Thu, Aug 14, 2008 at 7:50 PM, Patrick Giagnocavo <patrick at zill.net> wrote:
>> Francois Dion wrote:
>>> I have a single page document which is laid out with database fields,
>>> kind of like a report if you will. I can display stuff like I want on
>>> the page, and move to next record etc. The only thing I've never
>>> figured out is how do you have a "Page bleh of blah". I've inserted
>>> the fields, but once I hit print, it asks if it is a merge, to which I
>>> say yes, and then it prints, but on all the pages it prints page 1 of
>>> 1.
>>>
>>> I'm sure there's a way. If I find a solution to this, I'd like to add
>>> a letter to each page (ie, page 1 = A, page 2 = B etc).
>>>
>>> Open to any suggestions.
>>>
>> Are you using a database or are you using a flat file as your datasource?
> 
> The data is in an oracle db, but I need to make this self contained,
> and I've been playing around initially with an open office

You need to create the data outside of the OpenOffice application, I
think.  Then just add the fields as part of the mail merge template.

It would be really easy to do this in Oracle with its extensive SQL
additions to base SQL, provided you are good at SQL.  Look into DECODE
as well.

--Patrick