A blank report prints that does meet the select criteria 2

[risman]

I am using CR 8.5, accessing SQL Server, 2000 Prof. O/S, and utilizing these reports in a Radiology application that uses hard coded "print triggers" to run reports. I want a Patient History report to run at the time their exam is scheduled, (if exam is today or in the future). This is no problem, but I do not want it to run for ER or Inpatients, just for Outpatients. The select formula
{outpts.file = "O"} works well for Outs but also returns blank pages, (except for inserted text fields). How do I supress those partially blank INP and ER reports from printing?

My other option is to use a batch job. Problem is, there doesn't seem to be a "date the exam was scheduled" field. Just a "date the exam was scheduled for" field. Any ideas?
Thanks in advance.

 

[synapsevampire]

Use the File->Report Options->Suppress Printing if no Records option.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[risman]

I tried it, but the printer still spits out a blank page. Can that be stopped?

 

[synapsevampire]

Hmmm, other than a new page before/after box somewhere being checked and somehow causing it, I'm stumped.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com