Thanks to all! Several people have suggested this very solution.
Thanks, Anne From: Joe Cocuzzo [mailto:[EMAIL PROTECTED] Sent: Friday, July 27, 2007 3:23 PM To: Miller, Anne; [email protected] Subject: RE: [MEDITECH-L] report longer than 600 columns You can use the NL=N attribute to suppress the CR/LF on as many lines as you need and put your fields in the picture, but that gets old. Also there is some limit to the number of lines you can use in the picture. Better to just use the picture to provide the record separator CR/LF and do all output in a macro. You can tack the delimiter on the end of the fields in the macro and send them to ! Here is quote delimited, text qualifer = "" D(34)_","_D(34)^DL, D(34)[EMAIL PROTECTED], @birthdate_DL^!, Etc Last field gets just a D(34) at the end not a DL You will have to reformat dates as needed, otherwise you get YYYYMMDD If you don't do some kind of output via the picture, the report gets nil pages and process spool files becomes a deadly trap and the cursor sticks in the nil page field. Joe Cocuzzo Vice President NPR Services Iatric Systems, Inc. Phone/Fax: (978) 805-4115 Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Web: www.iatric.com <http://www.iatric.com> ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Miller, Anne Sent: Friday, July 27, 2007 11:05 AM To: [email protected] Subject: [MEDITECH-L] report longer than 600 columns Is there a way to create a downloadable report for which that data would exceed 600 columns? (My latest request is nearly 1800 columns of mostly patient demographic/insurance data). Thanks for your help. Anne Miller, MBA Applications Mgr, Information Technology Western Maryland Health System Cumberland, MD 21502 voice: (301)723-5414 fax: (301)723-5422 [EMAIL PROTECTED] Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= 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
