Data Viewer Designer

Data Viewer Designer is the tool that configuration managers use to set up the Data Views that will be available to Data Viewer users.

More information and screenshots coming soon.

Data Viewer Designer Key Features

Data-entry Forms:

Data Viewer Designer enables a person nominated as the configuration manager to:

  • Select, organize and view the data you want to see

  • Create progress meters and categorize fields to aid in the analysis of data

  • Create detailed or summary views from the selected data

  • Keep your data safe by limiting access to the view to specific users

  • Create custom configurations for specific users to present the data they need

  • View data in a chart or grid

  • Define a navigator hierarchy to display views in a logical fashion

Query Builder:

The built-in Query Builder makes it quick and easy to build the queries, without any knowledge of SQL (Structured Query Language), that Data Viewer uses to display the data to the end user.  Easy to use drag and drop operation to select tables and fields.  Use joins to display data from multiple tables in a single view.  Data from different formats can be combined into one view without changes to the original data.

Use powerful SQL operations to apply inner and outer joins.

Powerful Form Report Designer:

Data Viewer Designer comes with a built-in form report designer.  This tool enables you to create simple or advanced formatted reports that can be displayed, printed, or exported in Data Viewer.  The Form Report Designer also allows you to layout the report any way you like, including multiple nested sub-reports.

Multi-column Grouping and Sorting:

Data Viewer supports multi-column grouping and sorting, two very useful data manipulation features.  Use them together or individually to display the information your organization requires.

Binning Scheme Designer:

Quickly and easily create advanced categories of various types of data. Multiple columns of data can be analyzed and automatically output to a unique value based on custom criteria for each value.

Field Info List:

The Field Info List is a grid that lists all the columns that will be displayed in Data Viewer. It has many powerful features.  This is where Bins and Calculated fields are added, including support for complex mathematical expressions.  The built-in expression build makes easy work of any complex math that needs to be added.

Navigation:

The number of views and reports that can be created is unlimited, so simple navigation to these views is very important.  Easily create configurations and groups to organize the views in a logical and straightforward manner.

Database Driven:

All the configurations are stored in a central database, so any user in the entire organization can be given access to any number of configurations (and specific Data Views).

Data View Selection:

Hundreds of Data Views can be created, but not all users of Data Viewer need to see all those Data Views.  Some Data Views are created for Managers, some for analysts, and some for support staff.  The Data View Selection screen makes assigning multiple Data Views to multiple users very quick and easy, just by clicking a few buttons.

Microsoft SQL Server™ and Oracle™ Database:

Supported database engines are Microsoft SQL Server 2012 and newer, as well as Oracle.

Connect to these database engines to utilize the impressive power of SQL Server and Oracle.