Search results for query: *

Yes it is a string format as indicated below: 03/23/2004 Gayla

You have been very good in helping me but I cannot get your suggestion to work. I have tried this through my extract file which is what I am trying to manipulate. I get a "bad-date type" returned. When I try to go around the extract file and link directly to the database, I get a linking...

Disregard the getting lost question, had pulled in wrong field. Gayla

I feel stupid but I got lost on the "Next, place these formulas in the details section, right click on each, and insert a summary (sum). Drag the summaries to the group header #4 and then suppress the details" Please explaing the insert a summary. How do I do that? Do not see "insert a...

Sorry I incorrectly stated what I did. I did set the crosstab up in the lastnameid group and created the crosstab with the row to be transid and the column to be clockindate. However the manipulating that I will have to do is that I can not really use the clockindate as this would create the...

Ok, I have tried to do the crosstab and I like the way it is set up however, synapsevampire is correct, I will have to do some manipulation on it. I am a new user and am not real familiar with what I am trying to do. I will try to summarize this a little better. Client needs a report that...

I have a report that I am trying to create that will show the following information: Mon Tues Wed Thurs Fri Sat Sun 3/22 3/23 3/24 3/25 3/26 3/27 3/28 8 4 8 8 3 4 sick...

As requested, here is my record selection. {RptAttendance.DivisionID} = "00000006" There is nothing in the group selection. I will try the suggestion given by Lido and see if I can get it to work. Thanks for the help Gayla

I will explain this as best as I can. I am using CR8.5 and am trying to manipulate a report that was written by my software manufacturer. It is a time and attendance report for a specific date range. The report has already been written and is fully functioning. I am only trying to do 2 things...

I need to know how to take and convert a time to the decimal equivalent. Example what I have as 8:30 needs to be 8.50. Can someone please help as I do not know where to begin? Gayla Newbie on CR8.5

I have a formula that is adding time for the day. So if people go to clock out for lunch, it adds the 2 times together to give a total for the day. Is there a way to put a condition on that formula specifing that if the hours are greater than "8:00" only show "8:00" on the...

Thanks Grelber, it worked! Like I said, I am a new user and have not had much experience yet with formulas. Thanks for the help! [thumbsup]

The following is an example of the format that the client sent to me showing me the fields and the way the information needs to be layed out in order to import into their system. Name,Employee ID,Location Code,Location Name,Department Code,Department Name,Date Worked/Absent,Number of...

I am a new user in CR8.5 and interfacing with an ACCESS database. Problem: I have a table that has a transaction description column. That column consists of the following descriptions: Sick, Vacation, Bereavement, Jury duty, Dock, Comp time, Personal Bus.,Regular, Clock time, Clock Time or...

Let me explain differently what I have and what I need: I have a table like the following Hours InDate TransDescription 8 10/1/03 Clock Time 4 10/2/03 Clock Time or Clock-IN 4 10/2/03 Sick 8 10/3/03 Regular Client needs to receive a CSV that would...

I am new at crystal reports and need some help. I am using CR 8.5 and retrieving data from Access. I have a field of a TransDescription that I need to do 2 things to. Any suggestions on how to do this will be helpful. I need to first replace anything that reads "Clock Time" or...