My suggestion would be to move your report to NUR.PC.WORK
Both statements here address the same QUERY [EMAIL PROTECTED]"NURWKLIS1"] [EMAIL PROTECTED]@patient,@int.base,@int.urn,@td.act.date,td.act.time,@td. act.ctr,"NURWKLIS1 <mailto:[EMAIL PROTECTED]@patient,@int.base,@int.urn,@td.act.date,td.act .time,@td.act.ctr,%22NURWKLIS1> "] The huge difference is that the first statement will return the last entry to that query if not blank. The second statement will return the entry specific to the other conditions of which date and time are of importance to you. Since you are going to query based on time, any blank will return as blank. I have attached a small report containing all the vital elements required for a report in this DPM, to provide an example for you. The following selects in the report are important. You may want to just leave them as they are. xx.undone EQ 1 xx.ck EQ 1 td.act.ctr EQ @Last(td.act.ctr) xx.ck references a code snippet which resides in a macro, that macro provides the pointer to the previously entered data if a cancelled entry is found. xx.undone filters out cancelled entries. I do not recall the exact purpose of the @Last(td.act.ctr) selection filter. I think it had something to do with limiting the number of records to the last record occurring during the date and time period requested. Gord Gordon Dowling [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Applications Analyst Huron Perth Healthcare Alliance Stratford, ON N5A 2Y6 (519)272-8210 ext2268 _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 03, 2007 10:03 PM To: [EMAIL PROTECTED]; [email protected] Subject: [MEDITECH-L] NPR HELP I'm looking for some words of wisdom in a NPR report in ADM.PAT that prints a nurse handoff report. I have several fields that are ccdqr.response values. The problem comes when this query has been answered on dayshift and then on afternoon shift, the IV or NG, or whatever it is has been dc'd. When afternoon shift documents, they leave the query blank because it does not apply. The problem then becomes the answer still shows on the report but it no longer applies. Is there any way to tell the report/field that is the query was left blank, that is a response? Here is what I use in the field: DAT=FREE LEN=10 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ] I realize this pulls the last documented response, but when documeting by exception, this causes the problem listed above. Any help would be appreciated. Thanks, Karen Hunter [EMAIL PROTECTED] _____ AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com <http://www.aol.com?ncid=AOLAOF00020000000437> .
NurPcWorkExample.npr
Description: NurPcWorkExample.npr
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit http://mtusers.com/mailman/listinfo/meditech-l_mtusers.com To check the status of the meditech-l, visit MTUsers.NET For help, email [EMAIL PROTECTED] Please visit and add information to the MTUsers WikiPedia at MTUsers.NET/mwiki ______________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l_mtusers.com
