Joined: 22 Dec 2009
Location: Malaysia
Online Status: Offline
Posts: 13
Topic: Record Selection Posted: 08 Aug 2011 at 10:04pm
Hi,
Job Creation: Job ID Casted From Shift Casted To Shift Casted Reject ----------------------------------------------------------------------------------------------- J1-XXXXX 04/08/2011 Day 04/08/2011 Day 10 0 J1-XXXXX 04/08/2011 Night 04/08/2011 Night 9 1 J1-XXXXX 05/08/2011 Day 05/08/2011 Day 9 1 J1-XXXXX 05/08/2011 Night 05/08/2011 Night 10 1 J1-XXXXX 06/08/2011 Day 06/08/2011 Day 10 0 J1-XXXXX 06/08/2011 Night 06/08/2011 Night 10 0 ----------------------------------------------------------------------------------------------
Batch Creation: Batch No Start Date Shift End Date shift Qty --------------------------------------------------------------------------------------------- B1-XXXXX 04/08/2011 Night 06/08/2011 Day 38
I am having production entries for every day and each shift (day,night) as shown in the job creation and from that entries i taken from 04/08/2011 night to 06/08/2011 day (highlighted in red color) casted pcs to create a batch.
Now i want to show only that job creation details (highlighted in green color) which are now falling in batch criteria.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 09 Aug 2011 at 4:58am
Where in your data do you define a batch?
I would do a left outer join from your job data to your batch data. Then add something like IsNull({batch_table.batch_no}) to your selection criteria for your report. (Your date range should be the other selection critera.)
This will show all jobs withing the date range that are not part of the batch that you created.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
