Re: [libreoffice-users] Re: Possible to write reports with relationship data?
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 adoptions tables each have a FK to the animals table. What I'm envisioning is a report that lists the fields for the animal, followed by an indented section showing a row for each medical care event, and another indented section showing adoptions for each animal. A query could potentially use a join to create individual rows composed of data from multiple tables, but that is really only practical for 1-1 relationships, or possibly 1-verysmallinteger relationships. If you still think this can work, could you explain how this would be done? On Wed, May 15, 2013 at 2:27 AM, Alexander Thurgood alex.thurg...@gmail.com wrote: 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 also included (indented and formatted properly)? Perhaps I'm misunderstanding here, but surely using a Query or a View which pulls in the data from your 1-to-N tables, grouped as you want them, as the basis for your report, would suffice ? Alex -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Possible to write reports with relationship data?
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? On Wed, May 15, 2013 at 1:13 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Have you tried doing Reports in Writer? Writer should be able to use the database as it's data-source and then you put the fields in the appropriate places with whatever formatting you like that Writer has. Regards from Tom :) -- *From:* David Karr davidmichaelk...@gmail.com *To:* users@global.libreoffice.org *Sent:* Wednesday, 15 May 2013, 4:42 *Subject:* [libreoffice-users] Possible to write reports with relationship data? All the report tutorials I've seen seem somewhat primitive, in terms of what kinds of structures can be printed. 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 also included (indented and formatted properly)? -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Possible to write reports with relationship data?
All the report tutorials I've seen seem somewhat primitive, in terms of what kinds of structures can be printed. 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 also included (indented and formatted properly)? -- To unsubscribe e-mail to: users+unsubscr...@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