Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Displaying lines based on a variable
OK, I edited OP to make it easier to understand. Hopefully, it makes more sense now. So my STOCK.QTY of ABC in bin DMG is 5. I need to show only the latest transactions that will match the qty of stock. So while there are 5 records in the STOCKTRANSACTIONS for ABC, I need it stop printing...- vshvidky
- Post #4
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Displaying lines based on a variable
Sorry, made it confusing with transaction numbers, trying to simplify the issue. TXN 5 is for a different product(DFE), so OH QTY for DFE is 1. And adding other transactions for ABC, you get OH QTY = 5. Each transaction just shows the adjustment for the product at that transaction, not how...- vshvidky
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Displaying lines based on a variable
Hi there, I have 2 tables: STOCK table and STOCKTRANSACTIONS table. The stock table shows me how much product I have in every bin right now. STOCKTRANSACTIONS have every product transaction recorded (could be in multiple bins). I am trying to display all the latest transactions that apply to a...- vshvidky
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 4 Other topics
