The requests for reports that we get runs the gamut. Most of the time, clients are looking to modify the existing canned reports that Allscripts offers with the Allscripts Enterprise Electronic Health Record (AE-EHR). Other times, clients envision a custom report that is unlike any of those currently offered and is unique to their particular organization. And still further, some organizations wish to fulfill reporting metrics to receive monetary incentives from initiatives such as the Physician Quality Reporting Initiatives (PQRI) and P4P (Pay for Performance) . Given the commonalities in the requests we receive, with our reporting solutions store, we have attempted to pick the most popular reports requested from clients and offer them via on-demand payment, download and installation.
We also receive a substantial amount of inquiries from clients as to what exactly goes into customizing existing reports and creating new reports. Clients are often curious as to what types of skill sets are needed. These organizations may feel that they are better suited to have their own personnel develop custom reports. For instance, the organization may have performed an return on investment (ROI) analysis and determined it makes the most financial sense to train their own staff to supply the multitude of administrative and “print” reports they require in the coming future.
That said, let’s get to answering the question of what goes into developing custom reports for the AE-EHR:
- AE-EHR Clinical Database Stored Procedures: These are used to extract data out of the database to render in the report. The stored procedures can be thought of as a “middle-man” between the database and the Crystal Report. More information on the basics of stored procedures can be found via the following link.
- Crystal Reports: Most AE-EHR reports are developed using Crystal Reports. Crystal controls the how the data extracted from the stored procedures renders in the final report. Crystal offers functionality for pivot tables, summary of data fields, grouping, custom formulas, suppression based upon data values, etc. For more information on Crystal reports tutorials, follow this link .
- Insert Scripts: There are several places that reports can be installed within the context of the application’s user interface (UI) – these are called “Calling Points.” Reports can be printed from the administrative workplace, and also added to the UI for the traditional “print documents” – immunization or results “calling point” for instance.
The most important ingredient to custom AE-EHR report recipes comes in the experience – specifically knowledge of the database schema. Knowing what tables to pull from, how tables are related, and what functions, stored procedures and existing custom reports can be utilized so as to not re-invent the wheel. Knowledge of advanced SQL querying is invaluable as well. If you would like to learn more, Galen is offering free EHR Reporting webcasts.
Let us know if we may assist your organization in developing and delivering custom AE-EHR reports. In addition to the reporting solutions store, we also offer training courses and reporting services for the Allscripts Enterprise EHR database, ETL database, Analytics and the ConnectR database. Please contact sales@galenhealthcare.com for more information regarding these courses and our reporting services.
Tags: Allscripts Enterprise EHR, Crystal Reports, Custom Reports, Extensibility, Reporting, SQL Server, Technical
