Print Page | Close Window

Record Selection

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14004
Printed Date: 29 Apr 2024 at 1:49am


Topic: Record Selection
Posted By: angarakiran777
Subject: Record Selection
Date 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,


Replies:
Posted By: sharona
Date 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
if mailto:%7b@parameter%7d=ALL - {@parameter}='ALL' then true else mailto:%7bfield%7d=%7b@parameter - {field}={@parameter }
 
 


-------------
sharona

Posted By: hilfy
Date 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


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window