Search results for query: *

Using Crystal 2008 with SQL Server 2008 R2 I’m trying to count records into weekly buckets for the previous 4 weeks. Unfortunatly I only have one test record that falls on a weekend and it is not falling into the correct bucket. Formula works properly to find Week 3 Start Date //start date of...

I am using Crystal 2008 on SQL Server. The data in column EDG.CURRENT_ICD9_LIST looks like this: 998.89, 780.2, V25.2 525.88 780 780.2 998.89 780.2, 998.89 799.8 998.89, 780.2 I need to select all records that contain EDG.CURRENT_ICD9_LIST in the range of 780.0 to 999.99, but I've only been...

I need to find the average time of multiple date time fields that are in 24 hour format. using Crystal 2008 with SQL Server. My report is grouped by department and patient class and I need to provide the average time of day a patient is discharged for both groups and overall for the report. I...

I need to group a report by the patients age at the time of the surgery by using the birth date and surgery date. The age needs to be in months and years. The groups needs to be: < 1 Month, 1 - 6 Months, 6 months - 2 Years, 2 - 12 Years, 12 - 18 years, > 18 Years Any and all help is...

I'm using Crystal XI with Oracle 10g. I have a report that has over 53 columns per row that I need to export to xls. I currently have all columns on one display line but I had to make them so narrow its difficult to determine which column is which when I need to move them around. Does anyone...

I'm using Crystal XI with Oracle 10g. I've read and tried several formulas from previous postings, but nothing seems to be working or I'm doing something wrong. My report is grouped by location and @roomname with several summary fields in both. currently the report sorts by the @roomname...

I'm using Oracle 10 g with Crystal XI. I am trying to create a room utilization report by room and day of week. I've tried using the formula found in thread767-1387024 by LB to count the number of Mondays, but I'm not returning the desired results. I return 8 mondays in January...

I'm using Oracle 10 g with Crystal Reports XI I need to create a manual cross tab (because of printing issues) with a column and header for each date for the previous 10 days. I'm using the following select statement to get the return records for the previous 10 days. {OR_LOG.SURGERY_DATE} >=...

I’m using Crystal XI with Oracle 10g I need to create a summary report of the total number of procedures done in combination or as a single procedure. I’ve read several postings on arrays, but can’t figure out if I can group by the results. The procedure data looks like this: PatientID...

I’m using Crystal XI with Oracle 10g The purpose of my report is to provide a count of the number of rooms running by half hour by day and then an average of the rooms running by date and by day of the week. The report runs for a month at a time and I have it grouped by Day of week and Date...

I’m using Crystal XI with Oracle 10g. The goal of this report is to identify case records that have overlapping times and I’ve been unable to get anything to work. My data looks like this: Log OR IN OR Out ------------------------------------------------------------ Log 1 12/21/2009 7:13:00...

I'm using Crystal 10 with Oracle 10 g. I need my report to select records with dates in the next 2 weeks, Sunday - Saturday. I then need a column with the total number of cases scheduled for each of those 2 weeks. Surgeon 9/27-10/3 10/4/ to 10/10...

I'm using Crystal 10 with Oracle. I posted my original issue on thread767-1502453 I've found if the ending timestamp is the next day I'm not collecting any minutes in my 23:00:00 to 00:00:00 formula. If the in time occurs between 11 pm and midnight I was to display the number of minutes...

We are running Crystal Enterprise 10. Is it possible to schedule reports for a specific business day of the month? Thank you!

I am using the formula below for each hour of the day summarizing the total minutes used by hour. This worked great until the end user says there are two possible sets of timing elements. Despite my efforts to modify the formula I cannot get it to work. Any help is appreciated. Every...

I'm Using Crystal Reports XI with SQL Server. My report requires one date parameter the "Survey Date". The goal of the report is to report the number of deficiencies in quarters for the previous 12 full months from the Survey Date. I can't display the correct quarter dates. I need to...

Using Crystal XI on a SQL Server database my report displays the number of patients, number of results and the average as well as the standard deviation of a patients blood sugar results by patient, department and for the report. I also need to count the number of patients that had a result...

My report (Crystal XI) has 2 groups - grp 1 provider reporting group and grp 2 provider. I'm using the New Page Before in the section expert in group 2 to print each provider records on separate pages. I now would like to place a crosstab at the end of each provider group but I want it to be...

I'm trying to alternate gray and white row shading in a summary report in a group footer row. I've used the following steps in the detail row of previous reports, but it does not work in the group footer. There is not an alternating pattern, its appears random. Does anyone have any other ways...