Welcome, Guest. Please Login.
05/02/24 at 18:30:02
News:
Home Help Search Login


Pages: 1
Send Topic Print
Crystal Report Lines (Read 1584 times)
carolg
Full Member
***


I Love EvoERP!

Posts: 169
Gender: female
Crystal Report Lines
10/28/09 at 11:43:10
 
We have a Crystal Report that prints a shipping schedule with one line desciption for each part #.  We utilize 3 lines or more in each sales order.  The first two lines come from the inventory file and the third and fourth lines are typed in by the sales department with special notes.  Our Crystal Report is only picking up the first line of each part #.  What is the formula for our report to pick up all lines pertaining to that part# and print it on our shipping report.  I will need to do the same with subsequent part numbers also.
Back to top
 
 
  IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1523
Gender: male
Re: Crystal Report Lines
Reply #1 - 10/28/09 at 12:01:03
 
You would want to grab the lines (bkar_invl_pdesc) from BKARINVL.B (for open SOs) and order them by the bkar_invl_cntr (counter) field.
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
carolg
Full Member
***


I Love EvoERP!

Posts: 169
Gender: female
Re: Crystal Report Lines
Reply #2 - 10/28/09 at 12:48:22
 
That sounds good but I not sure how to write up the formula.  i went into the formula workshop to the description  line but I am not sure how to add "order the lines by the counter field".
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print