To understand how the DBReport works we need to understand the concept of bands.
A band is a box where we put objects, the most important band is “Detail” which is the only one who can not erase. This (Detail) is printed for each row or record of the RecordSet, ie if we have 10 rows or records we have 10 bands “Detail”.
The band “page header” is printed first in the top of the page for each page in the report generated.
The band “Page footer” is printed on the bottom of the page for each page in the report generated.
The band “Report header” is printed after the band “page header” on the first page of the report.
The band “Report footer” is printed just after the last band printed on the final page of the report.
Group bands are bands that are printed before the band “Detail” like “Group Header” and then like “Group Footer”. They print to change the group (field of recordset) or at the beginning of the report in the case of “Group Header” or end of the report in case of “Group Footer”. You can have as many group bands as needed.
The objects that can be placed in the bands are:
- Labels: are text like “Title Report” or the system date as “# date” or page number like “#pag” parameters or formulas.
- Fields: field name as “name” or “id”.
- Lines: horizontal, vertical or oblique.
- Rectangles Boxes or rounded rectangles.
- Images: Can be an image file or a RecordSet field.
This video shows some aspects of above.
The parameters are data (String, Picture, Array …) needed in the report but not in the RecordSet such as company name or username. These are assigned before printing or before displaying the “Designer” with instruction eg:
rpt.Parameter(“Company”)= “Company Name”
This video shows parameters and other things.
This video shows groups.
This information is provided “As-is”. All trademarks, logos, etc. belong to their respective owners.