A template in myDBR is an HTML/CSS/JavaScript code block used to format report content. It can contain any valid HTML, CSS, or JavaScript, allowing for free formatting of the report content and the creation of strict forms and other user-defined formatting.

The benefit of using a template is that it allows the separation of database queries from the presentation.

A template consists of a header, row, and footer. The optional header is an HTML block that will be output before any report content is displayed. The row is repeated for each row in the result set, and the optional footer is displayed after the result set has been processed.

A template can be fully defined in the row section if your query returns only one row. If your query returns multiple rows, you can define separate header and footer elements.

See Commands / Templates for more info on how to use templates.