Greetings, Excel doesn't report back it's "end" the way text files do.
I'd suggest you use filtering in the DataStation Report configuration. When you are adding the fields you want to display, the first field in the list can be used as a "filter" - and there is a config dialog for setting what the filter should be. Move Status to the top of the list and set the filter for records with a particular Status- Error for example. Or if you want all status to show up but not any that have no status (in your case blank rows) use: ! as your filter. Regards, Thom Thom C. Blackwell Product Manager Boston Software Systems (866) 653-5105 ex 807 <http://www.bossoft.com/> www.bossoft.com <http://www.bostonworkstation.com/customer_center/special_events.aspx> Sign up for my weekly webinar! LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately, then delete this message and empty from your trash. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craver Eric Sent: Thursday, March 27, 2008 3:38 PM To: [email protected] Subject: RE: [Talk] D.Report Do until d.eof From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Walker, Reese Sent: Thursday, March 27, 2008 3:29 PM To: [email protected] Subject: [Talk] D.Report I have a report that I am trying to run after a script is complete and it is pulling from an excel file. Even though my test file only has 10 records the report is creating a lot more. I am assuming it would try to do all 64000 lines in excel if I didn't kill it after it got the 1000. Is there something I can program in the D.Report line to only look at the first 500 records? This report should never have any more than that. Thanks, Reese Reese E. Walker Financial Systems Analyst Phoebe Putney Memorial Hospital Albany, GA. 31702 Phone: (229) 312-4259 Pager: (229) 431-7658 Fax: (229) 312-4316 _____ Disclaimer: The HIPAA Final Privacy Rule requires covered entities to safeguard certain Protected Health Information (PHI) related to a person's healthcare. Information being faxed to you may include PHI after appropriate authorization from the patient or under circumstances that do not require patient authorization. You, the recipient, are obligated to maintain PHI in a safe and secure manner. You may not re-disclose without additional patient consent or as required by law. Unauthorized re-disclosure or failure to safeguard PHI could subject you to penalties described in federal (HIPAA) and state law. If you the reader of this message are not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, please notify us immediately and destroy the related message.
