Alpha Video Training
Results 1 to 4 of 4

Thread: Help With a daily report to include all 3 shifts

  1. #1
    Member
    Join Date
    Sep 2005
    Posts
    6

    Default Help With a daily report to include all 3 shifts

    I am trying to print a report that will include the previous days production totals for a given SKU#. I have data that is from 1st, 2nd and 3rd shift of each day.
    In the morning I would like to print out what was done for each SKU# from the previous day.
    However, I want a report that will include todays (or last nights) 3rd shift and yesterdays 1st and 2nd shift totals.
    So if today was 2/2/07. I would want to print todays (or last nights) 3rd shift total of (2/2/07) along with yesterdays 1st and 2nd shift total from (2/1/07).
    I do have a [date] field and a [shift] field. and a [SkU#] field
    Any ideas on how to calculate this for a field on a report??
    Thank You!!

  2. #2
    "Certified" Alphaholic Mike Wilson's Avatar
    Real Name
    mike wilson
    Join Date
    Apr 2005
    Location
    Grand Rapids, Michigan
    Posts
    4,212

    Default Re: Help With a daily report to include all 3 shifts

    I can only guess what your name is since you do not provide it, and I can only guess at what your database structure is, since you do not provide it either.

    You will not receive much help here when you do not begin with the understanding that those here just don't have the intricate knowledge of your system, and that while you might believe your words present some substantive explanation, they do not to this mans reading, and that is something you're challenged to provide, in order to receive assitance. At this juncture, from my reading, your description for assistance and help are.... unreachable. Sorry.
    Mike W
    __________________________
    "I rebel in at least small things to express to the world that I have not completely surrendered"

  3. #3
    "Certified" Alphaholic G Gabriel's Avatar
    Real Name
    G. Gabriel
    Join Date
    Oct 2004
    Posts
    7,204

    Default Re: Help With a daily report to include all 3 shifts

    In your report, create a group based on the shift.
    Simply drag and drop the sku field in the group. A window will popup nd ask you if you want the total, count, average..etc. Use the appropriate choice.

    To choose the shifts from yesterday, in the report properties, put the proprer filter.

    Start out with that and see how far you can go.

  4. #4
    Member
    Join Date
    Sep 2005
    Posts
    6

    Default Re: Help With a daily report to include all 3 shifts

    Thanks for the help.
    I finally figured it out.
    While in the Report Editor of my selected report that I want to print.
    Went to the "report" drop down menu.
    Selected the "Detail Properties".
    Typed into the Filter Expression Area of the DETAIL PROPERTIES selection. This....
    (DATE=DATE()-1.and.SHIFT=1).or.(Date=DATE()-1.and.shift=2).or.(DATE=DATE().and.shift=3)

    It seems to work for me for now.

Similar Threads

  1. Calendar / Organizer / Daily Planner Style
    By warmexxus in forum Alpha Five Version 7
    Replies: 0
    Last Post: 01-24-2007, 04:24 PM
  2. Daily Calendar print
    By John Burke in forum Alpha Five Version 5
    Replies: 4
    Last Post: 07-15-2005, 05:12 PM
  3. Email a Daily Report
    By Mike Levesque in forum Alpha Five Version 6
    Replies: 2
    Last Post: 02-05-2005, 04:48 AM
  4. Force daily backup at close of database
    By Howard G. Cornett in forum Alpha Five Version 5
    Replies: 1
    Last Post: 06-26-2003, 01:48 PM
  5. Daily Incremental Backups
    By GregOnline in forum Alpha Five Version 4
    Replies: 2
    Last Post: 12-05-2001, 02:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •