[libreoffice-users] Re: Possible to write reports with relationship data?

Le 15/05/13 18:09, David Karr a écrit :

Hi David,

> No, I haven't gotten into that yet.  I assume I can do some sort of looping
> construct in writer that will allow me to step through rows in both the
> main table and the relationships tables?  Can I use Java or Javascript to
> do that iteration?

For iterative insertions of grouped data into a Writer document, the
mailmerge tool is often (ab)used :-) as the tool does this automatically
(well, it does, when it is working, which is LO version dependent ;-)).

If you base your mailmerge on a query (e.g. via a join) that fetches all
of your treatment entries for a given animal via the FK and orders them,
e.g. by date, then that should work.

What I haven't tried, is getting the results from two separate queries
into one single Writer documents, but in theory, this should work too. I
have been told, but again, not tried, that sections in documents can be
used to hold different queries, but I'm not sure whether the mailmerge
function would still work properly with this approach.


Alex


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted