Search results for query: *

I have a Subform which pulls a PayPeriod Date from a Table. The user populates the Pay period from a drop down list. I would like to restrict the user from using the pay period date more than once. Example If I choose 1-1-08 thru 1-7-08. I do not wish for the individual to have the ability...

I have creaed a form which allows me to view serveral calculations that are made when a person enters time value. The time values are entered in a subform and below the subform I created a button and then point the button to open up the form with the calcualtions contained within it. When I...

I am using Crystal 8.5 and I want to return deduction codes and values from Active employees who did not get paid. Here is my SQL that I have started: SELECT dbo.EBase.EbFirstName, dbo.EBase.EbMiddleName, dbo.EBase.EbLastName, dbo.EBase.EbSocNumber, dbo.EDeduct.DeeFlxIDDed...

I am currently using Crystal 8.5 and have a table that contains training information. Within this table I have a field that contains names of training classes which is populated by a choice list stored in a separate table. I want to display only the last record for a class, for example if I...

I have a program (ETS, written in VB6) which uses Crystal to generate reports. I am using Terminal services at mutiple locations hand have 7 different terminal servers (running Windows Server 2003) I have Crystal loaded only on one server. My ETS program generates (Unable to load...

I am in the process of transferring data from Access into SQL and I keep reciving the following error. Data for Source Column is too large for the specified buffer size. Can anyone help me with this error

I use Crystal 8.5 and would like to create a report which returns several percentages from data stored in one table. I want to calculate the percentage of events on the day of the week, time of day, location, if a physician was contacted, class of staff (regular vs part time contract etc)...

I have a DTS job which fails due to the following error: The number of failing rows exceeds the maximum specified. TransformCopy 'DirectCopyXform' conversion error: Conversion invalid for datatypes on column pair 3 (source column 'Soc Sec #' (DBTYPE_WSTR), destination column 'SSN'...

I am using Crystal 8.5 and I have created several If then formulas to replace code(Value Stored in the database) with text. The formula is listed below: Item 1 If {Incident.Location} = "BA" Then "Bathroom"; If {Incident.Location} = "BE" Then "Bedroom"; If {Incident.Location} = "NULL" Then...

I am using Crystal 8.5 and have generated a report which displays Employees Address1, Address2, City, State and Zip based on the current date and whether or not they have elected benefits for Medical or Dental. The report I have gives me the data I am asking for. My Question is this- Can I...

I am using Crystal 8.5 and I have a column of dates which I have formatted to appear as (12:00AM, 1:00AM etc). How can I place these into a table which shows the Hour and the a percentage based on the number of occurences in that hour from a total number of occurences?

I have a report which uses a date/time field. The data is stored in the database as follows (9/17/2005 8:00:00). I used the filters in Crystal to display the information Sat. My next goal is to add the common days of the week in the column and then divide them by the total number of...

I have a report which is run by administrators for each home in their area of responsibility and is submitted monthly. The report runs fine but each administrator has to repeat the process up to 20 times when all they are doing is changing a parameter (Home Name). Does anyone have any ideas.

New to Crystal but I ma getting the hang of things. I need to calculate a %change in weight from a column of information based upon the paramenters I have set. See example of data output Lakewood Gash Lillian 12/5/2005 106.00 Lakewood Greene Marvin 12/5/2005 113.00 Lakewood Streater Sammy...