Search results for query: *

Here is my problem: Name Stop Date Cost Check Joe Smith 1/1/1753 48000 1 Joe Smith 12/31/2008 46000 2 GF 46000 Jane Smith 1/1/1753 43000 1 Jane Smith 12/31/2008 41000 2 GF 41000 Subtotal 91000 I've...

I can do that, but the problem is that if I do that and try to calculate the payments, if an employee has 2 records, it will calculate both sums instead of just one.

Some Employees have both dates and the the majority have only the 1/1/1753. No, unfortunately those employees that have both dates, have multiple records. If an employee has multiple records, I need to be able to ONLY select the 12/31/2008 record, while still retaining the 1/1/1753 for those...

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

If I place (@7days) in the details db section, it counts all the records. If I place the (@7days) in GF2, where the (@display) is, I get the correct number. Is that the way it is supposed to be?

In which section would I put the increment formula?

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

This helps to get the correct days, but I want to be able to use this formula called (@less7): if isnull({@prevDisch}) then 0 else if {@Sum}<= 7 then 1. After this formula, I would like to be able to use either the sum or running total function, but I can't select sum on this field. The...

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

Thanks, that helped me out. I appreciate it. I wanted to ask you a question. Is there a place where I can learn all the extra stuff I can do i crystal or is it just by experience. Once again, thank you for everything.

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

Yes I am using the linking expert. I just double click on the current link between the 2 tables and change it from equal join to left outer join. Changing the links is my last chance effort to get the results I need. I need a total list of patients, and that includes those that do not have an...

In the Crystal 8.5 report, if I were to change any of the other tables to the right to left outer, I get those SQL error messages. In reality, I change all of those in crystal 11 to left outer joins and it works. But for some reason it won't do it in crystal 8.5

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