Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. okuser

    Problem with grouping

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

    Problem with grouping

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

    Problem with grouping

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

    Problem with grouping

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

    Problem with grouping

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

    Problem with grouping

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

    Problem with grouping

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

    printout to include info prior to today

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

    printout to include info prior to today

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

    Convert a time to the decimal equivalent

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

    when hours > "8:00" only show "8:00"

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

    Need help on formula

    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]
  13. okuser

    Need help on formula

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

    Need help on formula

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

    Need help with formulas "replace" and "If" o

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

    Need help with formulas "replace" and "If" o

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

Part and Inventory Search

Back
Top