Base Newbie Need help with report

[lcorley]

I have a simple table to organize entries for a show. Here is an example.

The finished one will have 20 or so classes and 50 or so rows. I need to be able to generate two types of reports from this. The first is an entry report. A document that contains a list of selected classes for each row in the table. The second is a class report. A document that contains a list of entries for each class. I cannot figure how to do this. I can configure the report generator to produce a report for a single class, but I can’t see how to make it iterate over all the classes. Are there examples of similar things in base that I can study? Or can someone offer suggestion? All my prior experience has been using a spreadsheet and Basic macros to organize views. Thanks.

[Wanderer]

There is a documentation available at
https://documentation.libreoffice.org/en/english-documentation/

Typically I create a special query first in SQL, wich contains the necessary data.

Reports for a class are done by grouping and sorting inside the report. For example the name of the class isbput in the header of the group, then detail for the group is repeated for all entries.

[Ratslinger]

Hello,

Have attached a sample. This contains two different directions (METHODs).

The first is based upon your single table and uses UNIONS in he SQL to get all the possible check marks. It is in the VIEWs created as Report Builder has some issue with sorting. If you look closely (all related items are noted as METHOD1…) it can easily get very lengthy with SQL as more classes are added. There is wasted areas in the field as not each animal is in each class.

With METHOD2, the classes are located in a separate table linked back to the master. There is no limit to the number of classes, the SQL (query used) is shorter and the report design is less complex.

Sample: ShowClassReport.odb (32.8 KB)

[lcorley]

Thanks for the suggestions. It was quite helpful. I’ve also noticed that almost every time I’ve had a question and did a search you have had a well-reasoned and well-written answer already posted. That has been a great help. Thank you.

Leon