Search results for query: *

I have a report in crystal XI where I need to calculate the payments that the company has to pay for all its employees. If an employee is active, their {BENEFITS.STOP_DATE} = 1/1/1753. Unfortunately there are some employees that have either 1/1/1753 or 12/31/2008. The majority of records has...

I have a report that I wrote in crystal 10 in which I'm trying to get the total readmisson days for a patient. If the patient has multiple records, I need calculate the days difference between the Discharge and Admisson Date. The report is grouped by Dr# and Patient Record#. I can successfully...

I have a report that I wrote in crystal 10 in which I'm trying to sum of a field that is using the previous formula. I need to be able to calculate the number of days it took for a patient to be re-admitted a hospital. Each patient is grouped by their account number. I have a current discharge...

I currently have a report that is pulling information off a 2005 SQL Server. I am trying to get the total number of tickets and work-orders for a given department. I have all the information I need for the tickets in the main report and all the information for the work orders in the subreport...

I'm currently running a report that will show me a list of all current employees off a sql server. In this list of employees, I use a table called HRUSERFLDS This table holds various data fields that pertain to each employee. Among these fields is the "Prev Yrs Experience" field. This field is...

Icurrently have a report written in Crystal Reports 8.5 off of a SQL Server and I need to left join some tables. When I change the tables to left outer join I get these error messages stating: General SQL Server: Check Message from SQL Server and Error Detected by Database DLL. When I revert...