Search results for query: *

I am using Crystal Version 12.2.4 running against an Oracle database. I am pulling the complaints and then using a group summary to calculate the count of complaints by month. DistinctCount ({pat_evt_ah.event_id}, {pat_evt_ah.event_dt}, "monthly") I have now been asked to calculate the Median...

I am using Crystal 10 and I have a report with a cross tab in group footer 4. This crosstab may vary in length and carry over to multiple pages. The patient name and medical record number display in group header 4, followed by other details and the the crosstab in the footer. The issue is...

I think I may have lost some brain cells during the flood last week, so I am hoping someone will have mercy on me and help me calculate the difference between dates on records using Crystal 10.0 to connect to some Oracle tables. I have date that is like this May 2008 (group) (Detail) Patient...

I am using Crystal 10.0 connecting to a view that has already been set up with the tables linked. I am unable to get to the tables to do different linking or use a command. Currently I am using a select statement and I get results that look like this Patient # Name Diag 1 Diag 2...

I am using Crystal 10.0 to hit against the Oracle tables for our Electronic Health Record. I am looking at three different tables and only want patients who appear in the first table and not in either of the other two. SO if they have hypertention and do not have CAD or Diabetes they should...

I am using Crystal Reports 10.0 to connect to our electronic medical record with an ODBC connection. I have a report that lists patients and the specific labs, the lab values and the date they have been done for certain diagnoses. The problem is that if a patient has never had the lab test...

I am using Cyrstal Reports 10.0 to connect to our electronic medical record with an ODBC connection. I am trying to get patients that come for appointments during a certain timeframe and who may have one of three diagnosis. My formula includes some OR statements. {RPTAPPT.APPTDATE}...

I am using Crystal 10.0. I have a report with calculations to compute a rate with variables in the report Footer. This is the only data on the report the users want to see. I have suppressed the details of the report as well as all of the group headers and footers except one of group headers...

I am looking for some help with grouping in Crystal 10.0. I have a report that list people in multiple records based on the tests they have had done. I only want to see the first test of the month (I found this by choosing the minimum date and placed this in the group)and then group on the...