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 Mike Lewis 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. RArcega

    Report Layout

    Hi, I'm trying to create this Recon Report but I'm having difficulty in doing the layout. This is the required layout When I'm trying to layout in crystal report, this is what I'm doing: and the result is not correct. [sad] can you help me, how can i produce the same layout as per...
  2. RArcega

    How to convert numbers in Crystal to hours.

    Thanks SkipVought for replying. I managed to get the time format for both formulas (eg: 230000 the output for both is 11:00:00PM) time(val(left(CLOCK_INB,2)),val(mid(CLOCK_INB,3,2)),val(right(CLOCK_INB,2))) time(val(left(CLOCK_OutB,2)),val(mid(CLOCK_OutB,3,2)),val(right(CLOCK_OutB,2))) so now...
  3. RArcega

    How to convert numbers in Crystal to hours.

    Hi, I'm having issue to get the total number of hours work of the employee and if the employee is eligible to some allowances. I have two columns in the table called Clock_in and Clock_out but the format is something like this 231000 (which is 11:10pm), etc. I managed to resolved the issue on...

Part and Inventory Search

Back
Top