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!

  • 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. Fermo Zolli

    Need help with formulas

    Hi, everybody, Tried to insert following formulas in one report of Crystal Reports: @pippo placed in the detail section: whileprintingrecords; numbervar pippo; pippo := sum ({LOCATION.SRLO_EFFECTIVE_VALUE}); @results placed in the group footer: whileprintingrecords; numbervar pippo; @Reset...
  2. Fermo Zolli

    Difference in hours for badging date and time activity

    LB, sorry, it took a while! Everything ok, but every time the date is changing, it counts the hours double. I also would like @Results to round up to entire or half numbers: how to do that? Finally with this report I am trying to sort data from 2 different databases. The one for badging and...
  3. Fermo Zolli

    Difference in hours for badging date and time activity

    Pleae find enclosed Excel file. Thank you, Fermohttps://files.engineering.com/getfile.aspx?folder=9c483074-1da5-4a90-a205-11d24f80c3fa&file=TMB.xls
  4. Fermo Zolli

    Difference in hours for badging date and time activity

    Thasnk you very much, LB ... and again compliments! This works fine now. My next questions now are: Having detailed records as: 15/12/19 13:44:24 IN 15/12/19 22:09:08 OUT 1) How to create a formula telling me that this time interval corresponds to an afternoon shift (standard 14.00 - 22.00)...
  5. Fermo Zolli

    Difference in hours for badging date and time activity

    Compliments LB! look really nice. Only one problem. Calculation is ok for all components inside group 1, meaning that all IN and OUT date are calculated regularly. @hrswkd will show the same amount in the raws of IN and OUT, as well as in @Result. But on last IN and OUT couple of each group 1...
  6. Fermo Zolli

    Difference in hours for badging date and time activity

    Group footer would also be ok, no problem. Thank you very much
  7. Fermo Zolli

    Difference in hours for badging date and time activity

    Hi, Sorry for late answer, ver busy this morning! Our pracice is that the hours will be calculated in the day I start to work, so in the IN day. IN and OUT are in a separated field, just in case I have to use it in the formula. the total worked hours should appear in the group 2 header, the...
  8. Fermo Zolli

    Difference in hours for badging date and time activity

    Hello, everybody, Tried many things but cannot get a good result. I have created a group 1 with user ID and a group 2 with date. Then in details I have all entries related as i.e. 08/12/19 05.43.59 IN 08/12/19 15.19.00 OUT This user worked in first shift. All entries are sorted with a IN...
  9. Fermo Zolli

    Shared Date variable not working

    Thank you very much, it works perfectly! I am so happy to finally discover to not be alone (with sometimes real headache)! why didn't I do that before! Another question: is thsat a way to bring the result at the same level of the main report in detail_a? One more time thank you very much. FZ
  10. Fermo Zolli

    Shared Date variable not working

    Hello, everybody, New in this Forum, With CR 2008 Version 12.3.0.601 I have created a subreport and edited a formula as follows: //@SubFormula //Returns the value that was stored whileprintingrecords; Shared DateVar DataCompletamento;{FOLLOWUP_STEP.WFFS_COMPLETION_DATE} (note: if I try to...

Part and Inventory Search

Back
Top