Query/Layout/Report (QLR) Manager (© 2003-2013 Tatler Software) is a web server application used to generate reports from databases. The application is 100% server based and only requires a newer, Javascript enabled web browser to begin generating professionally formatted reports. The formatting capabilities are extensive and include such advanced techniques as table and pivoted layouts for tabular output. Many different styles of charts and graphs can also be created from report output. After saving queries and their associated layouts, they can be easily combined into macros that provide for the generation of many reports and charts with a few mouse clicks. Queries and macros can also be used in the creation of user menus that hide all the SQL complexities from novice users, or restrict access to sensitive data.

In addition to merely viewing the output, report tools provide many options for e-mailing and downloading useful file formats. Report output can be downloaded as formatted output (HTML, MS-DOC, and MS-EXCEL), data files (MS-EXCEL, CSV, and TXT), or XML.

Contextual help is provided throughout QLR Manager and is associated with bold text and field labels, identifiable by or as these areas are moused over. The full User's Guide (this document) can be launched by clicking the in the Header.

To learn more about QLR Manager, please visit www.qlrmanager.com.

How QLR Manager is used

This application was developed to provide a user interface that is intuitive and easy to use for Restricted Users, yet offer powerful features for more Advanced Users. With the Enterprise Edition of QLR Manager, the Administrator can grant specific levels of authority to each User ID that can range from restricted access that permits running queries and macros from a menu, to an Advanced User that can author queries and layouts, define macros and create user menus.

Restricted User:

 •   Connect and select the Function for "Queries · Layouts · Reports".
 •  User Menu offers a selection of macros and queries the User ID has authority to run.
 •  Layout (optional) provides controls used to modify the appearance of report data generated by a query.
 •  Report displays output and provides tools to e-mail the results and download popular formats.
 

General User:

 •  Connect and select the Function for "Queries · Layouts · Reports".
 •  Menu offers a selection of menus containing queries and macros that can be retrieved and run. This includes the menu associated with the logged on User (*My Menu*) containing all the User's saved queries and macros.
 •  Wizard for creating and saving queries without any knowledge of SQL.
 •  Query editor for users familiar with SQL to quickly author and save queries.
 •  Layout provides controls used to modify the appearance of report data generated by a query.
 •  Report displays output and provides tools to e-mail the results and download popular formats.
 

Advanced User:

All the capabilities of a General User, plus the ability to define macros and create user menus.

 •  Connect and select the Function for "Macros · Menus · Forms".
 •  Define Macro to select from previously saved queries and layouts to produce output that can be viewed, e-mailed, and included in user menus.
 •  Create Menu to construct a highly customizable user menu that can be associated with specific User IDs.
 •  Design Form supports the creation of "Forms" that allow for the editing of data found in a database table.
 •  Preview for displaying the output for a macro or user menu. Also provides tools to e-mail macro output or download as HTML.