pull raw data from the database according to user-specified criteria and export it to Excel or another CSV reader.
allow the user to easily generate physician- and group-specific reports using virtually any combination of data field results and dates-of-service. Summary Report templates are created within the WellCentive application and are best for smaller and more straightforward reports.
allow the user to produce a wide variety of standard and user-specified reports in a host of formats, including charts, graphs, and gauges. Analytic Reports templates can be written directly in XML, or they can be created using one of three open source report designers. Any given Analytic Reports can be extremely complicated, and exporting data for reporting with Crystal Reports or another reporting tool is not necessary. The following information pertains to WellCentive Analytic Reports:
Flexible Report Layout
WellCentive Analytic Reports enables you to create almost any kind of report imaginable. Reports are built from a number of independently defined and formatted sections: Title, Page Header, Column Header, Group Header, Detail, Group Footer, Column Footer, Page Footer, and Summary. A report can contain any number of nested groups. On each group break, WellCentive Analytic Reports inserts a Group Footer and the Group Header for the next group automatically, enabling multiple levels of sub-totals.
Sections can contain layout elements like lines, rectangles, images, and static or dynamic text fields, as well as source data and computed data. All report elements can be precisely positioned and sized, allowing for pixel-perfect printed and web-based report layouts. Both single- and multiple-column reports are available. Data can be presented in flexible free form, tabular, cross tab (matrix), or chart formats.
WellCentive Analytic Reports easily handles the most complex report requirements through its support for sub-reports. Any report can be used as a sub-report within another report, and any number of sub-reports can be nested inside a report. Sub-reports can in turn contain other sub-reports down to any level of nesting desired, enabling arbitrarily complex report layouts.
Flexible Output Options
WellCentive Analytic Reports delivers operational information to wherever you need it: onto the screen, onto the printer, and to other applications. Output formats include PDF, HTML, XLS, CSV, RTF (Word), TXT or XML files. Some WellCentive customers use Microsoft Excel for further manipulation of the report data.
Comprehensive Charting
Many users prefer easy to understand graphical displays. WellCentive Analytic Reports supports an extensive array of chart types through its built-in comprehensive charting capabilities. External charting and graphics libraries can easily be used with WellCentive Analytic Reports.
Drill Down Analysis
Reports can contain hyperlinks, enabling you to create OLAP-style drill-down reports. These allow users to see a high level view of the data and drill-through to areas of interest. This feature can also be used to create a clickable table of contents for fast and easy access to report sections.
Custom Calculation and Variables
WellCentive Analytic Reports provides a comprehensive set of built-in variables and calculations, which can be extended with custom expressions.
Expressions provide the report developer with a way to perform calculations, create or compute groupings, generate report text, or to further customize the appearance of objects. Expressions can reference report parameters, report fields and report variables.
WellCentive Analytic Reports has various types of built-in calculation methods including count, sum, average, max, min, standard deviation, and variance. Calculations can be performed at various levels of scope, including at the report, page, column, or group level. Calculations can also be used to define the values of report variables that can be referenced throughout the report. Because they are implemented using arbitrarily scalable algorithms, there is no risk of overflow or underflow. Reports can also call out to your own specialized calculations.
WellCentive Analytic Reports provides a number of useful built-in variables that help with layout. They include the current page number, total number of pages, current column number, total number of records processed, number of records processed when generating the current column, and the number of records that make up the current group.
Graphical Report Designer
Several open source report designers are available for WellCentive Analytic Reports. WellCentive recommends the most popular of these, iReport, which provides an intuitive interface for designing reports.
The WellCentive OLAP Engine
The WellCentive Report Manager uses an Online Analytical Processing (OLAP) engine to dramatically improve performance.
The WellCentive OLAP Engine allows complicated reports, such as the Sample DM Report, to be compiled and generated extremely quickly. For a WellCentive Registry database with two to three years worth of data for over 100,000 patients, the Sample DM Report will be compiled and generated with the click of a single button in approximately one second.
No other patient registry system offers you the reporting options or report compilation speed that the WellCentive Report Manager provides.
The physician and physician group names in the Sample DM Report below are not real.