If anyone could assist I would appreciate it more than I can express, I am lost in Crystal Reports. I have SAP Crystal Reports 11 linked to IQMS Enterprise Databases for reporting and CoC Documents.
I am trying to figure out how to write the code to get Crystal Reports to search my TRANSLOG and pull a date from a specific transaction and I don't know where to even begin. I have my report showing the item number and FG lot number. I am trying to get it to search through the translog for that item number and look for the earliest "DISPOSITION" type transaction with a quantity greater than zero for that FG lot number and report the date of that earliest transaction.
If you can see it, below is a picture of the subreport this will go on along with an example screenshot of a translog with the line highlighted I would want the date pulled form for the given FG Lot.
The names of the categories when I click on the field within the TRANSLOG database are:
{TRANSLOG.ITEMNO}, {TRANSLOG.FG_LOTNO}, {TRANSLOG.TRANS_TYPE}, {TRANSLOG.TRANS_DATE}, {TRANSLOG.TRANS_QUAN}
I am brand new to crystal reports and am completely lost. I haven't even been able to write a nested if-then-else statement that looks at the QTYSHIPPED and if it is 2-8 displays 2, 9-15 displays 3, 16-25 displays 5, 26-50 displays 8, 51-90 displays 13, 91-150 displays 20, and so one to automaitcally display the number of samples checked for an AQL based on the total quantity shipped. I just have not yet been able to function in crystal reports.
Thanks in advance to anyone who can assist, I appreciate your time and any advice you may have. If you can't see the image or need more information and are willing to help please contact me.
Regards,
Josh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.