https://www.mediafire.com/file/k6thwbzk … c.rar/file

A small example of an interactive report in "FR". 2 reports in 1.
Hints are highlighted in red.
The example is based on the modified previous example with editing of the MEMO field and an empty grid to the end of the page.
The decorations and processing on the second form are also an example of FR capabilities.

A small example:
1. The simplest (by code) filling with empty rows of a fixed height to the end of the page.
    The number of output records for the test can be changed in the MasterData1.RowCount property.
2. The ability to edit the Memo field in the preview with further export or printing. Sometimes it is useful.
    In the test, for example, you can change the Signer Name OGGY (DblClick). For ordinary users, use with caution.
    You never know what they will fix )))

I need help creating a report to show data from main table1 and linked table2

SELECT student.fname, student.lname, student.grade, student.school_year, student.comments, trimesters.class, trimesters.trimester1, trimesters.trimester2, trimesters.trimester3
FROM student

INNER JOIN trimesters ON student.id_trimesters = trimesters.id_student
ORDER BY trimesters.class

When I run the report I don't get any data, just a blank report.

Right Now Report looks like
PageHeader
SN  Item Name Pcs
MasterData
1       item1         4
2       item2         2
Footer
         total           6

PageFooter

T&C Goods Once Sold will not be taken Back
------------------------------------------------------------------

What I Need

PageHeader
| SN | Item Name | Pcs |
| MasterData
| 1    |   item1        |   4  |
| 2    |   item2        |   2  |
|       |                    |       |
|       |                    |       |
|       |                    |       |// add this blank/empty lines to fill the space
|       |                    |       |
|       |      total       |    6 |
|------------------------------|
| PageFooter
|
| T&C Goods Once Sold will not be taken Back