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!

Search results for query: *

  1. applepie4th_7

    Crystal report - Subtract result for each item

    WOW LB you are amazing!!! I had these three in detailed section : QtyOrder | Qty To Commit | My_Qty And For QtyOrder, It's PacklistHDR.Quantity While for My_Qty(@backorder), I was using, {ORDERHDR.QTYORDER}-{ORDERHDR.QTYTOTCOMMIT} As soon as I changed My_Qty(@backorder) to...
  2. applepie4th_7

    Crystal report - Subtract result for each item

    Thank you for your response LB! I really appreciate that you took time to answer my question. I've tried all other fields that is associated with qty, ex Qty To Pick, QtyCommit, TotQty. But they seem to generate the same 'Sum' result. I've loosing hope but I don't want to give up!
  3. applepie4th_7

    Crystal report - Subtract result for each item

    Thank you for the quick response! All I've been doing is creating a formula {ORDERHDR.QTYORDER}-{ORDERHDR.QTYTOTCOMMIT} under Formula Fields as BackOrder. And place it directly to the detail section. I don't think I know how to do a sum Summary of @backorder.. (I'm new to Crystal Report.. )...
  4. applepie4th_7

    Crystal report - Subtract result for each item

    Thanks for the reply Ian. My actual values are the followings: QtyOrder | Qty To Commit | My_Qty (=@BackOrder is {ORDERHDR.QTYORDER}-{ORDERHDR.QTYTOTCOMMIT} ) 5 | 1 | 4 10 | 8 | 2 3 | 2 | 1 My current issue is that...
  5. applepie4th_7

    Crystal report - Subtract result for each item

    @Backorder is {ORDERHDR.QTYORDER}-{ORDERHDR.QTYTOTCOMMIT}. Please feel free to ask me any follow-up question. Thank you so much for your help
  6. applepie4th_7

    Crystal report - Subtract result for each item

    Hi, SkipVought. "{Table.1st_Qty}-{Table.2nd_qty}" meant 5-0 or 6-0 Table.1st_Qty is 5 & Table.2nd_qty is 0. whichever value that order is associated with. Basically My_Qty_1 is {Table.1st_Qty}-{Table.2nd_qty} And My_Qty_2 is {Table.1st_Qty}-{Table.2nd_qty} The problem I'm...
  7. applepie4th_7

    Crystal report - Subtract result for each item

    Hi, I'm in the desperate need of help of experts like you guys. On Crystal Report, I want to show My_Qty, which is {Table.1st_Qty}-{Table.2nd_qty}, for each item. My desired outcome is Item 1 5 0 5(My_Qty_1) Item 2 6 0 6(My_Qty_2) But my current CR shows Item 1 5 0 11 Item 2...

Part and Inventory Search

Back
Top