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

2013-05-15 Thread Tom Davies
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?

2013-05-15 Thread David Karr
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?

2013-05-14 Thread David Karr
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