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 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 > *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?
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 >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