Data Viewer

Data in databases is only helpful if it is displayed meaningfully.

Data Viewer, our primary universal reporting tool, is designed to cater to your needs by displaying data in a variety of convenient and intuitive formats.

Data Views are created in Data Viewer Designer, so end users do not need to understand the database structure to use Data Viewer.

More information and screenshots coming soon.

Data Viewer Key Features

User-friendly:

Data Viewer is so easy to use that a novice computer user can put the power of Data Viewer to work within a few minutes of instruction.

Live Data:

All the data that is displayed in Data Viewer is live.  This means that as soon as a record is saved in in the source application, Data Viewer can read that data instantly simply by pressing the refresh button (or by pressing the F5 key).

Powerful Grids:

The grids in Data Viewer are very powerful and extremely fast. Apply mathematical operations such as sum, count, maximum, minimum, or average to data columns. Group data by an unlimited number of columns and graphically view the results instantly.

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.

Filters:

Too much data?  Filtering enables users to focus on a specific range of data.  With the various filtering options, users can quickly and easily create simple filters on multiple columns of data and/or create advanced filters for more complex situations.  Each user can save and reuse their own filters over and over.  Filters can also be applied to all users for each view.

Conditional Formatting:

Make certain values stand out visually by setting the font and background colours based on some criteria of values in any of the columns in the grid.  Including formatting based on a mathematical expression.  The Conditional Formatting editor makes this task very easy to do.  Click on the View Screens button for examples of conditional formatting.

Flexible Reporting:

Create custom reports using data from multiple databases.  This powerful feature enables the user to easily create customized reports.

Graphic Display of Data:

Present the data in various charting formats such as pie, line, bar, stacked bar charts, scattergram charts, etc.  Multiple charts can be displayed on the screen at the same time.

Data Summary:

Create and save custom data summaries, enabling users to quickly view a synopsis of the data.  Summarize the data using Sum, Count, Average, Standard Deviation, Minimum, Maximum or Percentile.

Pivot Grid:

Quite often, more advanced methods of summarizing data are required. The Pivot Grid is a very powerful tool for aggregating data for many columns.

Export Options:

Data Viewer supports exporting data to the following formats:

  • Excel - XLS, XLSX, formatted or unformatted.  Formatted exports look exactly as laid out in

    the grid.

  • HTML

  • XML

  • CSV (text)

  • SQL Table in the connected database.  This is great for situations when a static snapshot

    of the data is needed.

Bins:

Bins are 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 of those values.  For simplicity to the users, Bins are created in Data Viewer Designer using the Binning Scheme Designer.  Those bins simply appear as columns of data in all parts of Data Viewer.

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.