Search results for query: *

I am thinking our IT department must not have installed the SQL expression builder when we did the upgradeto Crystal 12 as it isn't where it used to be. In addition when I try to do the command I get that I can't do this as it cannot be combined with Business Views... UUGH how can finding the...

LB - When I use your expression the Crystal formula checker says the ) is missing. I have copies and recopied and get the same thing. I am using this in the formula editor as I can't seem to find the SQL expression builder in this version (we are newly upgraded...) Any other ideas for me...

I tried placing the median on the graph and it is the median of the field and not the median of the distinct count of the field. I don't see how to place a median of a summarized field.

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

Not quite. I want the Header row which in my case show the patient name and the Medical Record number that is in the group header to repeat. I am good with the rows onthe crosstab itself. Thanks for taking time to respond though.

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

Thanks to anyway who was thining about help - I was able to get it to work using the previous function.

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

Thanks but this wont work for me because I may have three different results under Diag 1. A max would eliminate the other two from the list. THanks for the try though....

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

IT took me a little bit to get this to work but it worked great and I was able to get this request done. I really appreciate your help!!!

It is equal joined linked to the obsextract table by the PID. It is the first table and then everything flows from their.

The first table is the OBS_Extract table, this is then left join linked to these three tables [{HTN_EXTRACT.HOMELOCATION},{CAD_EXTRACT.HOMELOCATION},{DIABETES_EXTRACT.HOMELOCATION}] The tables are linked by a PID (patient identifier). All patients I want are in the OBS_Extract tables and then I...

Thanks LB but when I try this I get only patients that have all three of the homelocations and not ones that have only one of the three. This is driving me crazy because I thought your method would work.

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

Thanks for you help!! After about 10 tries I finally got everything suppressed and working. I appreciate you assistance!!

If I suppress the section or the blank subreport the formulas no longer work in the report footer. Any other ideas?

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