Report build wizard

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Report build wizard

DAB DAB
HI, I have two tables in a database, Customers and Dogs. One customer could have more than one dog.

I want to create a report which shows the customer details on one line but then the list of dogs that the customer owns before the next customer line and so on. For example:


John Deacon 18/05/1968
                Nelson, Cocker Spaniel, Male
                Loki, Cocker Spaniel, female
Barbara Barker 18/05/1975
                Patch, Springer Spaniel, Male
Karen Brighthouse !8/06/1985
                Nelson, Springer Spaniel, Male
                Bruno, Labrador, Male

What is the best way to achieve this?

Thanks

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

Reply | Threaded
Open this post in threaded view
|

Re: Report build wizard

Dan Lewis
  What you need to answer your question is described in the LibreOffice
Base Handbook available at this link:

https://documentation.libreoffice.org/en/english-documentation/base/

It is available in both the .odt (text format) and PDF for version 4.0.
Several years ago, AOO and LibreOffice split over disagreements
producing two variations of the same software. So, this guide's
instructions will work for both. Unfortunately, I could not find a base
guide for OpenOffice.

However I will mention this much. The first step is to create a
relational database with the two tables you mentioned. Then create a
query which combines these tables in which the relationship between the
tables is defined.  From here, detailed instructions are needed to
create the report you want. (This is why you need a guide to help you
with the specific steps.

Dan

On 11/23/20 04:47, DAB DAB wrote:

> HI, I have two tables in a database, Customers and Dogs. One customer could have more than one dog.
>
> I want to create a report which shows the customer details on one line but then the list of dogs that the customer owns before the next customer line and so on. For example:
>
>
> John Deacon 18/05/1968
>                  Nelson, Cocker Spaniel, Male
>                  Loki, Cocker Spaniel, female
> Barbara Barker 18/05/1975
>                  Patch, Springer Spaniel, Male
> Karen Brighthouse !8/06/1985
>                  Nelson, Springer Spaniel, Male
>                  Bruno, Labrador, Male
>
> What is the best way to achieve this?
>
> Thanks
>
> Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]