[geeks] open office writer and database merge

[Francois Dion]

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
spreadsheet. Would that make a difference using a jdbc link? or a
sqllite database?

Francois