Skip to Content

Crystal Reports Help - I'm brand new and clueless

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.