SQL template designer overview
Note:
The SQL Template Designer is considered to be an advanced feature, requiring experience in SQL (Structured Query Language) query development.
The following reporting capabilities are provided:
Out-of-the-box Report Templates: Report templates packaged with your installation.
Dynamic Template Designer: A tool to create custom reports by dragging and dropping database components, which are then used to dynamically generate the SQL query "behind the scenes" of the Portal.
SQL Template Designer: A tool to enable custom report creation using SQL skills. Query a large set of database published views to develop reports.
Customer Report Library: A collection of custom reports that you can use as a starting point, importing them into the Portal: http://reportlibrary.aptare.com/
The SQL Template Designer offers a way for you to augment your report inventory. Once you have become familiar with the report templates that are shipped with the Portal, you may want to design reports that draw on the rich set of data gathered by the Data Collectors, to serve your unique reporting needs. Using the SQL Template Designer and your knowledge of SQL, you can build advanced reporting solutions to support efficient storage resource management.