Search results for query: *

That worked! Thank you for your time Pete.

I apologize I was not very clear. My report looks like this: Week 1 Week 2 Week 3 Week 4 Start Date 9/15/2013 9/22/2013 9/29/2013 10/6/2013 End Date 9/21/2013 9/28/2013 10/05/2013 10/13/2013...

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

Thank you - this worked perfect.

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

Worked perfect. Thank you for the response and the link.

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

LB - Thank you for your time.

I apologize for not being clear, please let me try again. What I want is to be able to group by the string I've concatenated together "Scheduled CPT Codes" and provide the total number of times the same unique string of cpt codes was used. Currently my report is grouped by the patient with a...

I've used the formulas posted by lbass and it works perfect. Thank you lbass. But... I need to take it one step further and provide the total number of records for the group footer formula results. I exported to excel and used a pivot table, but if I can avoid excel and do this in Crystal...

Thank you all for your quick responses. LB unfortunately I don't have rights to install another print driver. I used the text rotation suggested by fisheromacse and it worked perfect, Thanks again ~ and have a great day!

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

Thank you LB I appreciate your time. This worked perfect.

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've added this to the Time In Range formula and it works great. if (date({@Surgery Dates}) in holidays) then 0 Thank you for your time.

I apologize for an incomplete post. The formula for holidays is in the report header: //Holiday Listing formula to go into the report header of the report. BeforeReadingRecords; DateVar Array Holidays := [ Date (2010,01,01), Date (2010,05,31), Date (2010,07,05), ]; 0 Time In Range Formula...

Now I need to exclude surgery dates that were holidays from my weekday total time used columns. I have a formula like this for each weekdayday of the week. DayofWeek5: If DayOfWeek({OR_LOG_SURG_DATES.SURGERY_DATES}) = 6 then {@TimeInRange} DayofWeekCounter: datevar array Holidays; datevar...

Removing while print records worked. Thanks Again LB.

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