Notifications
Clear all
Topic starter
Our clinical staff asked me to include the Pharmacy Name and fax number on prescriptions that are printed. That was a pretty easy, but had and unexpected side effect. If there was no pharmacy selected the entire prescription was blank. I am not that great with Crystal and was wondering how I can include a detail section that displays the data when it is present but does not impact the rest of the Crystal Report when it is not. Thanks.
Posted : May 6, 2013 11:09 pm
You need to create a formula called something like "Pharmacy" and it needs to contain something like:
StringVar pharmacy := ({PRESCRIB.pharmacy_name});
if pharmacy = ""
then "Pharmacy not specified."
else ({PRESCRIB.pharmacy_name}) ;
Something like that...
Then drag the formula into the report as if it were a database field.
Posted : May 16, 2013 2:12 am
