Recent content by mjm19

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

-LB Your last tip was terrific. Worked perfectly and the report is now concise with all parameters met. Thanks again .... Someday I'll get it !!

LB ----Thanks very much. As an FYI the limits defined for tests 1 and 2 displayed correctly, but I did get all test 3 results regardless if they were on the same orders (we sort by accession # ...If accession # B1234 had tests 1,2 and 3 it showed up, but if only test 3 was on accession # Y1234...

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...

-LB ... thanks very much. One more thing ... So it does change every ABCDEFG to 123456. How doI suppress the ABCDEFG code ?

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...

Thanks ... It works now. Very much appreciate your help, as always.

LB .... I did what you suggested in the group formula, but still get everything: COUNT ({Query.AccNumber},{Query.PtNumber}) >1 Even if I change the 1 to any number, I still get every instance of either the UA or UC orders whether together (which is what I want) or by itself (which I don't...

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...

Of course ....Thanks Ian. Brain Dead mjm19

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...