DBReport for Xojo (III)

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s