Search results for query: *

Crystal 8.5 SQL Database Hi, I have a report where I need to suppress data. In order to suppress lines that do not qualify for my formulas I placed a suppression in GF2 - which works. (I inserted summaries and used MAX to display my data in GF2).I also need to supress dupliate patient data (pt...

Crystal 8.5 SQL Database Good Morning, I am trying to calculate patient age by months. I have a patient date of birth field and am subtracting that date from a vst start date field to get current age. @Age=Month({vst.vst_start_date}) - Month({pt.birth_dtime}) When the report runs, I just get...

Crystal 8.5 SQL Database I have to write a report where I need to group specific charge codes by date. For example: Svc CD Svc Date Service DTotal (trying to get this #) 3610079 4/1/2005 1 1671008 4/1/2005 3610079 4/2/2005 1 1671008 4/2/2005 3610079 4/3/2005 1 1671008 4/3/2005 3610079...

Crystal 8.5 Hello all, I have written a report where my end user now wants fields not to be combined. I now need to trim out these fields. For example: physician name (pract_rpt_name) has last name, first name. I need to seperate these names. Also need address (addr_line1) which contains...

Crystal 8.5, SQL Database Hello, I wrote a cross tab report where I am trying to display the number of patient discharges by nurse station by hour. Nurse station is on left and time range across top. I have a formula that converts the actual time into the 'hour' of discharge. EX. if {@hour} =...

Crystal 8.5 I need to write report that returns patients that have multiple qualifications of the same field. Example: Need patients who have had hosp_svc equal to 'SRC' and 'SDS' and 'GNC' over the past year. I have tried the following- hosp_svc in ('SRC','SDS','GNC') hosp_svc in SRC and...

Crystal 8.5 Hello, I wrote a report that lists last name, first name. Some names have been entered with a single or double space before the name to differentiate them from the rest. Need to eliminate these spaces to have all names correctly listed alphabetically. Any help would be appreciated...