Report Designer Export Report Records
When creating a MEDITECH Report Designer "Export" format type of report, you must define record names for each data row in the report download file. Each record name will force a new row to be created on the report. Typically you don't want this. With most extract reports, you want all of the data to be displayed in one row, and all of the different fields to be displayed in separate columns on that row. This is typically how we setup extract files, in order for them to be opened with Microsoft Excel.
The issue is that there is one data "Record" associated to each "Record Name" on the extract report and the fields that you can add to that row on the extract report are restricted by the record associated to that row. The first field that you type into the "Record Name" section of the report determines the MEDITECH data Record that is associated to that row.
So, for instance if the data record you are using is "RegAcct.main," then you can't just add the field "EdmAcct.EmergencyDepartmentDepartDateTime." to that row. You can add the Edm field to the report if you create a new "Record Name" (or row) and make sure that the Edm record gets associated to that row (EdmAcct.Main). However, the problem with that is that a new row will be created on the extract report, and you probably don't want to do that. You could setup a rule in the "RegAcct.main" row and build all of the Edm fields as calculated. However, there is a much easier solution. All you need to do is create a new "record" in the report, but instead of giving the record a new "Record Name" use the exact same name as the previous Record Name. This will cause the data on the second "Record Name" (or row) to appear on the same row as the first record.
Related Articles
Report Designer Rule Functions - Date/Time and Other String Conversion Functions
When building Report Designer rules there a re a bunch of date/time functions (and others) available in the string conversion functions. Here are some MEDITECH articles that are a great reference when using these functions. I have also included the ...
Report Designer Rule Functions
https://customer.meditech.com/en/d/prwrd/pages/rd6basmatrulefunctions.htm
Patient Lookup On Report Designer
To get the patient name, number, lookup on a report designer report use the RegAcct.AccountNumber with override data type value of object identifier, pointer RegAcct and pointed to field AcctNumber. This give user the ability to use name, medical ...
BarAcct Transaction Types for 6.1 MEDITECH Patient Accounting (B/AR)
Transaction Type Mnemonic Name ADJ ATE BCS BDX BFW BPR CCX CEA CED CHG CLM CLT CPX CQD CRM CSQ CSR CSX DEL DIS GED IBX IED INT LTR MRK NTC NTE PAY PST REF REV RMC RPR SED SGC STM TSK Adjustment Account Type Edit Biller/Collector/Coll Stream Edit Bad ...
Extract and Convert Base64 Data from MEDITECH Outbox Message
This is a C/S NPR utility. Run this program from the front end: ; ; Arguments: ; A = MIS.XO.MSG.urn ; ; This code will retrieve an outbox message, save it locally, ; then extract the base64 content out of the message and save it to a ; binary ...