Working with the SQL Template Designer > Steps to Create SQL Templates
  
Version 10.0.00
Steps to Create SQL Templates
Use the SQL Template Designer to create custom reports by developing SQL (Structured Query Language) queries to tap into the StorageConsole database. See SQL Template Designer Overview. Also, visit the Report Library for additional report template examples:
http://reportlibrary.aptare.com/
This section includes details for the following SQL Template Designer options and features:
Create a SQL Template
Configure SQL Template Scope Selector Components
Construct the SQL Query
Sample SQL Queries
Use Functions in Queries
Format the SQL Template Output
Use Functions in Queries
Advanced SQL Report Template Option - Drilldowns
Advanced SQL Report Template Option - Mouse-over Hover
Exporting/Importing SQL Templates