Search results for query: *

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

I just asked this question and had an answer that is really easy. In the chart expert highlight your field and choose &quot;order&quot; then &quot;specified order&quot;. From there you can pick which data elements you want and under the &quot;Others&quot; tab you choose, 'discard' others...

Once again I'm turning to all of you experts. I'm trying to add a crosstab report in a group footer. I'm trying to use a cross tab to show what a patient's intake and output were for each time they were taken. It looks like Time1 Time2 Time3 Totals Intake 5...

This worked great! Thanks for pointing me in this direction, I've never tried using the specified order function. Thanks again!!!

My 1st group is: Adm.PatientName and My 2nd group is: Assesment.VS which will have several different responses: Pulse, Temp, Sa02, Respirations, Intake and Output. My 3rd group is Assesment.VS.DateTime which shows the vital sign response and time taken. I've put my chart...

Ok, I'm stumped! I have a report with 6 different group representing vital signs. The Groups would be Pulse, Temperature, O2Saturation, Respiration and Intake and Output. (All of the data comes from the same table). I can easily make line graphs that show up in each individual group footer...