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 have the report grouped by class. If I leave max statement out the report returns all records even those records that have expired and then been replaced by a new record.

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

LB, I am getting the error on the percent formula. I was able to create the percent calculation for hour but when I combine it with a calculation for Day of the Week my Grouping is incorrect. I know I need to solve this with a formula and was wondering if you could point me toward some...

Lb I get an error: The Summary/Runninbg totla field could not be created

You assumed correctly. What do you mean by? Then add a unique ID field that identifies a specific occurrence? I understand the part about the formula I not clear on where I need to place the Unique ID. By the way thank you for your help

I have an occurence on 2/13/2006 8:00:00 and an occurence at /13/2006 9:00:00. The result I am looking for is 8A 50% 9A 50%. The date range will be determined by the paramenters entered.

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?

Mo and Synpsevampire, Thanks for the suggestions. I am using Crystal 8.5. I keep going around in Circles. I have gotten the percentage to show but in a cloulunar format. Example: Date Desc of error Day of week of Error Pecentage 11-05-05 Med missed...

mister mo, Thanks for the information. I understand what you mean by DayofWeek. Could you forward the formula to add these items

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.