Recent content by reitter

Got it -thanks for the help!

I figured I needed to do this in a few steps. Any of the numbers that are 4 digits (internal extensions) always will have the following area codes/prefixs: 520-694-xxxx I did copy the formula below and this does get all of my 4 digit numbers to a 10 digit format - but it causes any number...

I have a 3000+ spreadsheet that lists fax numbers. The problem is sometimes the number is only 4 charachters (an internal extension) but it could also be a regualr 10 digit phone number in the field or a 7 digit phone number. I need to get all numbers into the following format (000)-000-0000...

That works!! Thanks so much this is what I was trying to accomplish but I was going about it all wrong.

Ok, I've substituted my tablename {vResultsforCitation.ClinicalDTTM} in plast of 'table.date' pasted this in my formula and I keep getting errors atthe 'between convert' text. What am I not doing correctly?

it is in the select statement.

I'm trying to finish my select statement for a Crystal10 report. The users want the data based on 4:01pm the previous day to 4:00pm on the current date. We will set the report to run daily at 4:30pm. The field in question is a DateTime field. I'm drawing a blank on how to make this work.

I'm using an SQL database with Crystal 9. My report has 3 groups: GH1 = DOCTOR GH2= SERVICE DATE (by month) GH3= INPATIENT OR OUTPATIENT GF3 = TOTAL # OF CHARGES FOR Inpatient or Outpatient per Month. I'm using a running total field to total. In my GF1 (doctor) I've got a graph that...

Thanks for your answers, I was getting hung up trying to make the parameter where the default ties to a specific field. I didn't realize you didn't have to tie a parameter to a specific field. Thanks again for such fast responses!

I'm using Crystal 9.0 with a SQL database. The database has the following 2 fields: PositionDate AnniversaryDate I know that I can make each one of the fields have a parameter Date Range for my user to enter when they run the report. My question is since date range would be the same...

For each PcsPocQueryID (such as IV.Assesment) there would be many entries, at least once per shift that the nurse documented. I'm only interested in the last entry made for each specific query, which would be reflective of the actual patient condition. My tables in this example would be...

Right now my report looks like rh section A Logo field <patient name> various manual fields to be filled in after printing. (new page after) rh section B Name: field <patient name> Does the patient have a living will? field<yes/no> Does the patient have...

Thanks for both of these answers. Neither of these options work. By using group1, I'll end up with approximately 40+ groups, so the data in the group footer continues to repeat. I've also tried the topN funtion and I can't get that to give me any data. I've put the TopN formula: if...

I'm using Crystal 9.0 with a SQL database. My end result is a 3 page form with fields that would be filled in based on specific data elements. So far I've made my form in the report header using 3 sections with a new page after each section. I have 1 group in the report which I've hidden...

I'm using Crystal 9 from a SQL 7 data respository, this is what my data looks like: Time1 Time2 Time3 Totals Intake 5 5 5 5 IV Intake 10 15 20 15 Totals 7 10 12 My totals are showing up as 'avg'...