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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by odins701

  1. odins701

    Calculate who is onsite now

    You are right and awesome! screenshot below...
  2. odins701

    Calculate who is onsite now

    so... 7 people have been onsite today and 1 is onsite now.
  3. odins701

    Calculate who is onsite now

    right he came back, so only 1 person is onsite now. it shows 7 onsite now (currently)
  4. odins701

    Calculate who is onsite now

    Ok, did that. getting same total as the total been onsite. Screenshots below...
  5. odins701

    Calculate who is onsite now

    ok, its attached. do you need the sub report as a separate attachment?https://files.engineering.com/getfile.aspx?folder=8662620b-851c-4f5e-9c2e-da7446f2c6f8&file=OnsiteNow_3.rpt
  6. odins701

    Calculate who is onsite now

    there is no personal info in the test db
  7. odins701

    Calculate who is onsite now

    can i send you a copy of the report to look at? i can make it downloadable from dropbox. i can also include a backup of the test db if needed.
  8. odins701

    Calculate who is onsite now

    only 1 formula in the sub-report using shared variable, @onsite and 1 formula in the main report referencing the shared variable
  9. odins701

    Calculate who is onsite now

    is this correct?
  10. odins701

    Calculate who is onsite now

    what do you mean by shared variables?
  11. odins701

    Calculate who is onsite now

    ok, that cleared that error up, thx! screenshot below shows the results, but the count onsite now is 0.00 (i'll format that once it's good), should be 1...
  12. odins701

    Calculate who is onsite now

    i'll do that right away
  13. odins701

    Calculate who is onsite now

    i removed it from the main report (it was blank) and get same error.
  14. odins701

    Calculate who is onsite now

    Whileprintingrecords; Shared Numbervar onsite; If remainder(sum({READER.TIMEATT},{EVENTS.EMPID}),3)=1 then onsite := onsite + 1; in the subreport
  15. odins701

    Calculate who is onsite now

    Ok, all that is done. When i preview the report i get the error below.
See more

Part and Inventory Search

Back
Top