Search results for query: *

I should know this, but am currently braindead. Running Crystal 8.5 and trying to capture only that data that is stored as a string that starts with ADDON. Of the 19,000 patients I had on the original report from yesterday only a few had an Order Comment of ADDON. I only need to see those few...

Crystal 8.5 / Win 2000 I have a report that prints all the account numbers for patients within a given time frame. Simply put, I just want to see those patients without one. So while printing records I just want the null values to print. Thanks for any help. mjm19

Crystal 8.5. Have tables & views made to display the data I want, but this formula escapes me. Doc wants all patients that have a result of Test 1 >60 and Test 2 <100. At the same time he wants to also display Test 3 no matter what the result is. The criteria for Tests 1 and 2 is straight...

Hi, Using CR8. I have a coded result that comes over in a result field that needs to be converted to the same number everytime. In other words the code ABCDEFG is the result that I need to convert to 123456. This must be pretty simple to do, but escapes me. Thanks

Have used the following in CR8 to capture specific results. if NumericText (Left ({Result_View}, 1)) then ToNumber (ExtractString ({Result_View}. "",",")) else 0 I'm trying to get all results >300 for a particular test using CR9. If the result is = >5000, CR9 does not pick it up using this...

Using CR 7.5 trying to capture results in a hospital setting where the value of a test is pending. The result field from the database is blank: Pt Number Test Result 12345 TSH 1.50 12346 TSH 12347 TSH 5.00 I've tried using different...

This should be easy enough to do but escapes me.Using Crystal 8.0 with an ODBC / MSQL Database in a hospital setting. Doc wants a listing of those patients (group by patient ID) that had test A and test B done on the previous day. I can get ALL instances of A OR B, but only want to see those...

Hi, We are one of the largest networked facilities on the East Coast that has a once a month system downtime. During the last one, the Seagate Info Server got clobbered somehow. Queries were lost, and scheduled reports run off those queries were all messed up. To make a long and frustrating...

Hi, Using CD 7.5 with an Intersystems Cache ODBC driver. The data I get in a crystal report (dealing with multiple patients in a hospital setting) needs to be exported in a character separated file like so: T65324|SCLINT|1/13/2004| 4:40:00AM|; AORTIC STENOSIS| This works well, but the third...

Having a problem setting up what should be a pretty basic formula. Using Crystal 8.0. Searching for a particular test that was ordered yesterday. Have a group made up of Patient Unit Numbers. Then listing the occurances that this test was ordered on that patient for a given day (accession #)...

Using the format editor, it is easy to click on suppress if duplicated. However in this report, I only want to see duplicated values. A dialy query runs giving me all the data I need from the previous days lab results from a hospital. In this particular case, I'm searching for this...

In the Format Editor there is a field where you can simply check off to suppress duplicated data. In the case I have on this report I want to do the reverse. All the data is there, I just want the duplicates. This report runs off a query like so: {Query.TestCode} in [&quot;MRCM&quot...

This should be easy, but I'm stumped. Using Crystal 7.5, need to access our Cache' database, and only get certain tests (this is a Hospital) that were collected on the previous 4 Saturdays and Sunday's only. I can get them all for the previous month but how do I set up a formula to only get...

Need a formula to accomplish the following: If the patient has results for test A AND test B AND the result for test A = X AND the result for test B can be either L,M or N then display on a report. The key here is that the patient has had requests for both tests A and B. No matter what I do, I...

I'm using Crystal Reports 7.5 and pulling various reports from a standard query. All works well except that the data that appears at the end of page one repeats itself at the beginning of page 2. The data is complete on page 1. This follows thru on every page throughout the report (i.e the end...

Run a query every day that accesses all patient data from yesterday. Now need to run a report against that query that searches for data from a selected population. That selected population is stored on the SFA in the form of an individual 's unit number (i.e. &quot;1234567&quot...

Have a database of 3,000 tests at a hospital. What's the best way to write a formula or parameter to give me only those patients that had Test 1,2 and 3 done together. In other words I only want to see the data if all 3 tests were done on the same sample, not just 1,2 or 3 separately. Thanks...

I'm making a report for a Hospital where it looks for tests that were cancelled or refused due to a problem. Some order codes are &quot;batteries&quot; that can contain up to 50 tests within itself. The report searches for the result looking for [Corrected. This works just fine. I can suppress...

Is there a formula out there that tells a user upon completion of a report that it did indeed search the database, but found nothing that qualified for the report. Need to run a daily report that rarely finds data, but when it does, needs to be acted upon immediately. Regulatory issues have come...