Report is not reporting correctly. 1

[luv2bike2nv]

Crystal Reports 8.5 (i know its old, i would upgrade however it is not my decision), Pervasive 8.60.
I was asked to create a report that would show the on-time and late delivery from our vendors in our mrp software. Setting up the report was a piece of cake, The DB’s I used were PO Receipt (for: when received, how many received ), Part Master (just needed this DB for Description) and Order Master (for: order number, line item #, Del item #, part #, Original quantity, original due date).
When i run the report, and say one PO has 6 line items with different part numbers, quanitity, received quanitity, etc for each line. CR will have the 6 line items for EACH of the line items.

Please see attachment link for pdfs for an example of the problem: PO for tektips.doc ----Original PO
Cr reportsfor tektip.doc - the Crystal Report
Cr design.doc --- report design


I hope someone can help me out on this issue. Why would the report pull each line item 6 times, have the correct description, part number, quantity correct on all 6 lines and one of the lines the received amount is correct however the other 5 lines will have what was received for the other line items. (I hope this makes sense.

Thanks so much.

Side note:

Our MRP software has a report that is kind of what my user is looking for however my user wants to add a couple of columns, delete a couple of colums. I can not do those adds and deletes because of the DB that the MRP system used to create the report makes no sense to anyone BUT the consulting team at the software company, so i figured i could create a report with the DB's i mentioned above since it has all the fields that I need. ughhhhh..

 

[lbass]

How did you link the tables?

-LB

 

[luv2bike2nv]

Part Master - Prtnum_01 to Order_Master - Prtnum_10
Order Master - Ordnum_10 to PO_Receipts - Ordnum_55

 

[lbass]

I think this could be a linking issue, but I don't know enough about the tables or what fields are in each. I would think you might lead with the Order Master table->PO Receipt and then link the PartMaster to the PO table, but I don't know for sure. It might be appropriate to link more than one field, too.

-LB

 

[luv2bike2nv]

Ok I will give that a try and will get back to you...either today or tomorrow. I appreciate your assistance
Robin

 

[luv2bike2nv]

made the changes to the links, the switch got rid of the extra lines however it is now not reporting the correct quantity that was ordered. so I cam going to continue to play around with the db links and see what i can come up with. Thank you LB for your assistance.