click to enlarge

User Login

Optionally enforce user authentication using a login prompt. Users with various permission levels will have privileges to specific functionality. User-specific permissions will determine the visibility and accessibility of features to that user.

click to enlarge

Main Menu

The user-interface consists of 3 main sections.
The main menu provides all options relating to settings that modify reports, compilations, database connectivity and other output options.
The direct access section presents a listing of all reports belonging to specific compilations or not belonging to any compilation. The various output format links generate immediate report output in realtime.
The 3rd section is provided to select and enable the currently active database for report definitions using the visual report query builder.

click to enlarge

Administration

Setup the parameters for database connectivity from which report queries will extract data. Other options include the selection of databases to allow access from UNIGEN, custom query builder header/footer messages, explicit referential integrity linking for databases that do not define key constraints, field aliases and selections for hiding tables from the report query builder.

click to enlarge

Visual Query Builder

This is the visual report building tool. It enables you to select data directly from the currently active database using drop-down menus, and to select various criteria, result groupings, and aggregate functions. The dense layout is simple to use and cannot be simpler for the attainable complex results. A report can be created as simply as selecting the data you need from the first column of drop-down menus. More elaborate filtering requires use of the other options. One row or more defines a single piece of information retrieval such as a person's age within a certain range.

click to enlarge

Compilations

This is the highest level of hierarchical report organization. Compilations are a grouping of reports that make it possible to combine multiple reports into a single presentation of textual and/or graph output from various reports. A report may belong to a collection of reports called a compilation, or it may belong to the "General Reports" category of belonging to no compilation. Compilations generally contain reports that collectively convey accurate meaning.

click to enlarge

Output Attributes

The advanced output attributes specify data placement within a report and modify attributes of rows and columns of information. This includes the field of separation for a report and enables multiple report records to interweave with each other whenever a value within the specified field for separation changes. A useful feature when consistently interweaving separate information into one continuous listing.

click to enlarge

Tabular Output Settings

Textual output settings are applied to the data font attributes including font type, size and colors for the field headings and data types of a tabular report.

click to enlarge

Graph Output Settings

Both common parameters to all graph types and parameters specific to each type of graph are modified from within this section. The general appearance is highly customizable and includes: labels, visual effects, graph element dimensions, color schemes, element visibility, backdrop images, etc.

click to enlarge

Conditional Formatting Styles

Modify the output format styles associated with fields according to specific criteria. Conditions can be simple or complex containing group-by-precedence, conjunctions, various field-value references and valid PHP code/function calls for comparison.

Generate reports containing color coded data for enhanced depictions of tabular reports. Quick and easy interpretation of crucial changes in data alert you immediately.

click to enlarge

Generated Reports

This is just a sample of what was generated from the demonstration database included with UNIGEN and by the click of a button on the direct access listing of pre-defined reports.

click to enlarge

Generated Reports II

Sample compilation of two sequential reports generated in the demonstration by the click of a button. Includes a conditionlly formatted report with color coded data.