Working with the SQL Template Designer > Format the SQL Template Output
  
Version 10.0.01
Format the SQL Template Output
1. Format fields in a report within the Formatting tab.
• Check the query fields to select the fields to be displayed in the report.
• Move fields up and down to position them in the report’s output.
• Modify the Label for the displayed fields to something more relevant to your needs.
• Modify the Number, Size, Date, and Time Formatting.
• Modify the Alignment, Aggregation, Bar Type, and Bar Type Color.
2. Choose a Report Type:
• Bar Chart: Configure a Bar Chart SQL Template
• Donut Chart: Configure a Donut Chart SQL Template
• Gauge Chart: Configure a Gauge Chart SQL Template
• Area/Stacked Area Chart: Configure an Area Chart SQL Template
• Horizontal Bar Chart: Configure a Horizontal Bar Chart SQL Template
• Horizontal Stacked Bar Chart: Configure a Horizontal Stacked Bar Chart SQL Template
• Pie Chart: Configure a Pie Chart SQL Template
• Pivot Table: Configure a Pivot Table SQL Template
• Stacked Bar Chart: Configure a Stacked Bar Chart SQL Template
• Table: Configure a Table in the SQL Template Designer