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