Skip to Content
0
Jul 16, 2020 at 09:35 PM

Crystal Reports Help - I'm brand new and clueless

73 Views

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