Report Writing

Interoperability and EHR Optimization

Privacy and Security

NPR Tip: "Echo Name" feature for Customer Report Screens (MAGIC Only)

You may have noticed that MEDITECH standard NPR report screens can have "display only" fields, but in customer reports, there is no attribute or standard method to provide the same feature. In a CDS, you could just set the "Echo Name" flag to Y when building the screen.

Read More

DR+SQL Tip: Using UNION to Best Effect

MEDITECH migrations platform bring many challenges; one of them being that you may find yourself with a new LIVExDB in the picture and once you’re past the go-live you find that data is flowing only into the new LIVExDB and not into the old one anymore.
Read More

NPR Tip:  What Happened on March 1st 1980?

MAGIC and Client/Server Time Stamps and how to use them.

Example Reports

Report with "elapsed time" information

Export of Doctor Dictionary Entries created or edited on/after selected date.

List of NPR Reports "run since" elected date

Read More

NPR Tip: Keep Users Entertained During Download or Printing (MAGIC or Client/Server)

If you have a report that users are going to run and wait for, it can be nice to print some kind of progress message to the screen to keep them entertained.

The easiest way to do this is to use the @W.display macro, which will show a message in a window while the report runs.

Read More

Stop at Query if Patient is "on Coumadin" (MAGIC Only)

Someone from Mid Columbia Medical Center in Oregon asked for a way to stop at a query only if a patient was "on coumadin." I am going to interpret that to mean any active PHA order for Warfarin (administration of the drug not checked, although you could add this if needed).

Read More

SQL Tip -- Check Tables for Data

One of the challenges of the Data Repository (DR) is that we often need sets of tables populated with data and, despite everyone’s best efforts, when the rubber hits the road – one of them is empty. The MT task to get it turned on missed it, or you were doing it yourself with a self-service Special IL (if you’re on C/S or MAGIC), and you skipped one yourself.

Read More

Writing files from NPR report to a shared folder from a scheduled or submerged report (MAGIC Only)

The only "officially supported" mechanism to write a file to a non-MEDITECH machine is to use FTP. This means you need to set up an FTP as a service on the destination machine, which typically involves installing additional software.

Read More

NPR Tip (MAGIC or Client/Server) – Report to Download with “CSV” Extension Opens Immediately in Excel

At MUSE 2014, the most popular "tip" was probably the demonstration of an NPR report that allows the user to send output to "DOWNLOAD" with a CSV extension on the file and two footnotes on the report allow the just created file to open automatically in Excel. No "End of Report" message to close. No need to find the report flat file and open with Excel.

Read More

Run Report for Period without prompting for date range (Client/Server or MAGIC)

It is common to have a report that should be run for a GL period (here we assume this is a calendar month) and the easiest way to program this is to prompt for a date range and let the user figure out how many days in the month. You can add some error checking to reject an ending date that is not the last day of the month with an "FCL" attribute, but another approach would be to prompt them for the GL period and write some code to get the start and end dates based on the period selected.

Read More

Utility Report to Assist with Syntax Checker Changes – MAGIC, Client/Server or 6.x

As most Report Writers are aware, the customer version of the NPR report writer includes a "syntax checker," which does a string search of source code and a string search of object code to attempt to block commands that could delete or alter data.

Read More