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

2013-05-15 Thread Alexander Thurgood
Le 15/05/13 18:09, David Karr a écrit : This too, might help you along : http://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=10865&p=51051&hilit=two+queries+in+one+writer+document#p51051 As I mentioned in a previous response, I'm really not sure about whether you can insert two different q

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

2013-05-15 Thread Alexander Thurgood
Le 15/05/13 18:09, David Karr a écrit : Me again. > 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

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

2013-05-15 Thread Alexander Thurgood
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

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

2013-05-15 Thread David Karr
Let me give some example background to see if this can work. Let's say we have an "animals" database, for someone maintaining an animal shelter. Each animal has a list of "medical care events" and also a list of "adoptions" (some animals return to the shelter). The "medicalCareEvents" and "adopt

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

2013-05-15 Thread Alexander Thurgood
Le 15/05/13 05:42, David Karr a écrit : Hi David, > If I have a main entity, and I have two one-to-many relationships to other > tables (FK links from the other tables to the main table), is there any way > to generate a report with the main table data, and the data for the other > relationships