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.thurgood@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+unsubscribe@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+unsubscribe@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