I might have stated this before, but we sometimes run into this issue
where Datastation reads a blank cell as a record. So you need to also
check for If D("1") = "" Then Quit
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -
717.972.8123 sendplaintext
________________________________
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.
