Search results for query: *

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

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

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

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

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

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

I have a field pp.name (last name,first name,mi)which will return data like: Mouse,Mickey A. Of course the names are all variable lengths but they are separated by a comma. What I need to do is make 3 separate fields: Last name, First Name and Middle Initial I can't seem to locate any...

I'm Stumped! I'm using Crystal 7.0 to distribute reports. I have 1 report that once I distribute to a specific workstation and try to run it I get the CRUN32 error. I've deleted the datatbase ODBC connection and re-added it. I've deleted the report and redistributed it, renamed it and...

I've been working on this for MUCH TOO LONG and I can't get it. I've got a main report that is group by Therapist and a subreport that is also grouped by the therapist. I'm linking the two reports by the same field and service dates. The sub report shows up in the right place on the main...