 |
| Tuesday, 01 August 2006 07:00 |
|
Tricks of the Trade: NPR Client/Server -- Pulling Fields from Other Modules Without Using a Fragment Contributed by: Pat Korolog, Applications Specialist II, Kalispell Regional Medical Center. When you are creating a report there is often a need to pull a field from a DPM other than the one in which you are writing your report. The most common way to do this is by creating a fragment report and linking that report to your main report. There is another way to pull fields from another DPM without writing a fragment report. Let’s say the user needs a report for which most of the fields reside in ADM.PAT, but wants the balance out of BAR.PAT. We need to do four things to get this field from BAR.Write a macro to set up your custom list:
AL START open macro will open up the BAR database (BAR.XXX will be your BAR database).
AL D get.data macro will link to the BAR account and use the BAR.PAT.number.x to look through the BAR accounts.
AL CLOSE.UP close macro will close the BAR database.
Finally, we need to place the field BAR.PAT.balance on the picture of the report.
We can also create a computed field and subscript the value we need. We still need to open and close the database. Here is an example of a report that is written out of ABS.PAT but we need a field from MRI.DRC. Our footnote would look like this: AL START %Z.link.db(Q("MRI.XXX"),Q("O","B",1)) AL CLOSE.UP %Z.link.db(Q("MRI.XXX"),Q("C","B",1)) Our computed field, xx.pat.city would look like this: DAT=FREE JFY=L LEN=20 VAL=@MRI.DRC.pat.city[@mri.urn] The above information should help you with a couple of ways to obtain fields from a DPM other than the one from which you are writing your NPR report.Pat Korolog, RN, is an Applications Specialist II for Kalispell Regional Medical Center. Pat has over 12 years of experience working with MEDITECH HCIS, performing implementations, applications support, and NPR report writing and training. |
MeditechBulletin.com and MeditechCareers.com are not affiliated with MEDITECH, Inc.
Columns
Upcoming Events
