All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ======================================
Hi Chuck, You could remove your Detail Region (enter a 'N' for Detail on Page 1). You could then create three xx fields and place them in your TR region: xx.yes DAT=PINT FNC=TOT LEN=5 [EMAIL PROTECTED]"QUERY"]="Y" 1} xx.no DAT=PINT FNC=TOT LEN=5 [EMAIL PROTECTED]"QUERY"]="N" 1} xx.blank DAT=PINT FNC=TOT LEN=5 [EMAIL PROTECTED](@cd.response["QUERY"]) 1} Z.count will return the number of records that are on your report. Good luck, Brian Schmit Sr. Programmer, Picis Direct: 781 557 3315 Fax: 781 557 3140 100 Quannapowitt Parkway Suite 405 Wakefield, MA 01880 [EMAIL PROTECTED] www.picis.com Please visit www.picis.com/meditech for additional information about our NPR Report Writing Trainings. The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access or use by any other person to this internet email is not authorized and may be unlawful. If you are not the intended recipient, please delete or destroy this email. If you do not wish to receive future emails from the sender, please reply directly to this email requesting you be removed from any mailing list. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Lovelace, Chuck Sent: Thursday, April 13, 2006 1:18 PM To: Meditech-L Subject: [MEDITECH-L] TOTALING AN NPR REPORT All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ====================================== I am trying to write an NPR report to pull the results of a specific query, I want to just list the totals of how many yes, no and blank, and how many patients the report looked at. I am writing the report in ADM.PAT. I'm getting totals but its printing a line for each patient. All I want is one page with all the totals. Here are my selects and sorts: Sort Field Order Header Trail 1 facility ASC NONE N 2 date ASC NONE N 3 urn ASC NONE N 4 status.type ASC NONE N 5 xx.adv.dir ASC NONE Y Select Field/Prompt or Value 1 status LI Status: 2 date GE FROM DATE: 3 date LE THRU DATE: 4 xx.adv.dir EQ "" Has anyone written anything like this??? _______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l _______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
