A BAR analyst from a C/S hospital posted a request to the "Meditech-L" mailing list, asking for help in including the last billing comment and last billing comment date on a BAR.PAT report.
A report request arrives on your desk – complete with screenshots of screens from MEDITECH complete with circles and arrows. But the fields are unfamiliar… a query to the requestor for a Shift-F9 and screenshot of the resulting pop-up yields nothing. “Ah,” you think, “custom queries on a CDS, document section or intervention. Why oh why didn’t MEDITECH code Shift-F9 so it would tell us what query mnemonic was in play? Why?”
For tips on using the DR Data Def Tables in CS/MAGIC 5.67 or MT 6.07/6.15, please see this updated post.
One of the challenges of DR-based report development is the same as for NPR or RD… where is the data you want stored? One way to find out is to go into MEDITECH and find the field, and – if you are lucky – you can do:
NPR report writers at MAGIC sites probably know that you can write code anywhere in a MAGIC report to put a file name into /ZFTP.TITLE and if the report is scheduled to Auto FTP, the file name created by the report code will be used instead of the default file name based on the report title.
When you use sort headers on an NPR or Report Designer report, you can print the sort values on a line above the detail items like so:
Creating a download report is streamlined in the Report Designer, although it was not that difficult in the NPR Report Writer. If you designate a report format as Export rather than Standard on the General page, the Regions and Layout Pages become unavailable and the Fields page has a setting for download:
The Regions Page allows you to activate different regions, and to create count and statistical fields for your trailer regions. Rather than creating a computed field with a VAL and an FNC, you can create a counting field per record (so count at the detail level or at a child segment level or both) or a statistic for a numeric field.
Some aspects of the new Report Designer are actually nicer than those of the NPR Report Writer. Field selection and field placement on the picture is quicker and easier. Of course, if you have the NPR RW keystrokes and NPR RW functionality burned into your neural pathways, you might think that you are doomed, but you may have felt that way when you lost 10 function keys going from your Esprit 105c to a PC but I bet you cannot describe the difference between the fat, skinny, and double arrows now!
Don't be fooled by the blue highlighting on data in a field in the Report Designer. Just because the data is highlighted, this does not mean you can do something to it (like delete or change it).