Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Record Selection Post Reply Post New Topic
Author Message
angarakiran777
Newbie
Newbie


Joined: 22 Dec 2009
Location: Malaysia
Online Status: Offline
Posts: 13
Quote angarakiran777 Replybullet 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.

Please help i need this report very urgently.

Best regards,
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 09 Aug 2011 at 4:54am
create a parameter for batch number
if you need the option to run all batches in a date range
add ALL to the parameter
in the record selection
 
 
sharona
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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.
 
-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.016 seconds.