Format the SQL Template Output

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 Labelforthe displayed fields to something more relevant to your needs.
- Modify the number, size, date and time formatting.
  See Number, Size, Date, and Time Formatting.
- Modify the alignment, aggregation, bar type and bar type color.
  See Alignment, Aggregation, Bar Type, and Bar Type Color.
- Modify the area, line or column, sparkline format for an SQL tabular report template.
  See Area, Line or Column Sparkline Format for a SQL Tabular Report Template.
Choose a Report Type:
Header/Footer
Click Header/Footer button. IT Analytics displays Report Header/Footer dialog box is displayed.
In the Footer field, specify the current date and time using : ${currentDateTime} and then click OK.
For example: Report generated at ${currentDateTime}