Sql Template based report is a relational report based on SQL Report as a template. This report type is useful when report designers do not understand the database schema. Any SQL report can be used as a template. In the view mode of an SQL report, just click on the design button to use this SQL report as the template.

You can also use Temple based report designer to create Temple based reports. First make sure that Temple based report type is enabled: Admin > Selected report types. When designing a template based report you can choose the columns, order, groupings and filters.

• Select a base SQL Report
• Click a checkbox to select filters
• Click a checkbox to select columns
• Click up and down arrows to change the column order
• Click "Use Group By" if you want to reduce the report to a summary. Aggregation formula dropdown will for each column. Numeric columns will have different selection list than text columns. Select appropriate aggregation formula.