Re: [libreoffice-users] Possible to write reports with relationship data?
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
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