Information in databases is only useful if the data is displayed in a meaningful way. Data Viewer is our primary generic reporting tool for displaying data in multiple convenient and intuitive formats. Our clients use Data Viewer for the general reporting of all our applications as well as any other kind of reports the users want. Data Viewer a great reporting tool for our own applications but it can be used to view data from any supported MS SQL Server or Oracle database locally or remotely (depending on the database security). The true power of Data Viewer lies in its ability group, sort, filter, summarize, and chart data in nearly any way imaginable. Our clients find Data Viewer indispensable because it can provide powerful analysis of their data far better than any other tool they have ever used.
The data that users are allowed to see in Data Viewer is controlled by designated users of Data Viewer Designer.
Data Viewer 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 on data columns. Group data by unlimited number of columns and graphically view the results instantly.
Conditional Formatting: Make certain values standout 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.
Multi-column Grouping and Sorting: Data Viewer supports both multi-column grouping and multi-column sorting; two very useful data manipulation features. Use together or individually to display the information your organization requires.
Fast Searches: Instantly search any text in any of the columns in the grid much like a Google search.
Filters: Too much data? Filtering allows users to focus on a specific range of data. With the various filtering options, users can quickly and easily create simple or 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 particular view.
Graphic Display of Data: A picture is worth a thousand numbers. Present the data in several different charting format such pie, line, bar, stacked bar charts, scatter gram, 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: Quit often more a advanced method of summarizing data is required. The Pivot Grid is a very powerful tool for aggregating the data for many columns.
Export Options: Data Viewer supports exporting data to 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 snap-shot 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 a 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.
MS SQL Server and Oracle Database: Supported database engines are Microsoft SQL Server 2008 and higher as well as Oracle. Connect to powerful databases to utilize all the power of SQL Server.