January 31, 2022

Write NPR Reports to cross-over multiple databases of the same application

Suppose you have multiple BAR databases (BAR.DB1 and BAR.DB2, for instance).  When you run an NPR Report, you are prompted to select one of those BAR databases.  

You can, however, modify your report to include data from ALL of your BAR databases. 

For MAGIC sites, simply add MIS.APPL.multi-database as a Sort Field.  For C/S sites, add MIS.APPL.DB.multi.db as a Sort Field.  When you translate your report, you will see a message like this: This is a multi-database report.

 This works not just for BAR but for any application with multiple databases.

Topics: Report Writing, Magic System, NPR Report

You Might Also Enjoy

In the MEDITECH NPR DPM MIS.GL.PERIOD, there is an index (table) called date.x (Logical ...

Sometimes an NPR Report crashes and a screen pops up with some information about the ...

Sometimes a field from a Child Segment has multiple lines of free text. Let's assume the ...

Meditech has a great utility program in C/S in NUR for modifying the length of a ...

IPeople was thrilled to be back at the annual MUSE International conference after a ...