Problem in Exploded report

Discussion in 'Free Source Codes' started by Rishi kumar, Aug 30, 2023.

    
  1. Rishi kumar

    Rishi kumar Member


    Dear sir

    I am creating a exploded sales report.
    Sir when I exploded the report , invoice first item repeated twice and all its value repeated.
    For ex. If invoice has two stock item them first stock item repeated twice instead of displaying second item and it's value.
    That's wrong sir
    Pls guide

    Thanks
    Rishi
     


  2. Sai Vineeth

    Sai Vineeth Active Member


    you need to post code you are using also.
     


  3. Rishi kumar

    Rishi kumar Member


    Ok .. I am Posting Exploded Part Coding

    Line where Explode Attribute Used:

    [Line:LWDetailLine]

    Field : Cust Month , Cust Inv no , Cust Inv Date , Cust PO No ,Cust OrderRef ,Cust OrderDate ;;6
    Right Field : Cust Customer Name , Cust Bill To , Cust Ship To, Cust Destination, Cust Product ;;5
    Right Field : Cust Item Des , Custt Lenght , Custt Width , Custt Thickness , Cust Net Qty ,Cust Gross Weight, Cust NoofPackets ;;7
    Right Field: Cust NoofSheets , Custt Pack Mode , Custt LR ,Custt LR date,Cust TruckNo ,Custt Transport , Cust Driver Contact
    Right Field: Cust Payment Terms , Cust Freight Terms , Cust BasicPrice , Cust TaxableValue , Cust FreightAmt , Cust packingCharge
    Right Field: Cust InsCharges, Cust SGST, Cust CGST , Cust IGST ,Cust InvValue , Cust TCS , Cust HSN , Cust CustGSTNo , Cust CustPanNo,Cust LC Ref
    Local : Field : Default : Style : Normal
    Local:Field:Default:Align:Centre

    Explode:SLedDup_ReportsDescExp2:Yes

    Border : Thin TopBottom
    Option : Alter on Enter

    [Part:SLedDup_ReportsDescExp2]
    Line: Shipping Explode
    Repeat:Shipping Explode: InventoryEntries
    Scroll:Vertical

    [Line:Shipping Explode]
    Field : Cust Month , Cust Inv no , Cust Inv Date , Cust PO No ,Cust OrderRef ,Cust OrderDate ;;6
    Right Field : Cust Customer Name , Cust Bill To , Cust Ship To, Cust Destination, Cust Product ;;5
    Right Field : Cust Item Des , Custt Lenght , Custt Width , Custt Thickness , Cust Net Qty ,Cust Gross Weight, Cust NoofPackets ;;7
    Right Field: Cust NoofSheets , Custt Pack Mode , Custt LR ,Custt LR date,Cust TruckNo ,Custt Transport , Cust Driver Contact
    Right Field: Cust Payment Terms , Cust Freight Terms , Cust BasicPrice , Cust TaxableValue , Cust FreightAmt , Cust packingCharge
    Right Field: Cust InsCharges, Cust SGST, Cust CGST , Cust IGST ,Cust InvValue , Cust TCS , Cust HSN , Cust CustGSTNo , Cust CustPanNo,Cust LC Ref

    Local : Field : Cust Month : Set as : ""
    Local : Field : Cust Inv no : Set as : ""
    Local : Field : Cust Inv Date : Set as : ""
    Local : Field : Cust PO No : Set as : ""
    Local : Field : Cust OrderRef : Set as : ""
    Local : Field : Cust OrderDate : Set as : ""
    Local : Field : Cust Customer Name : Set as : ""
    Local : Field : Cust Bill To : Set as : ""
    Local : Field : Cust Ship To : Set as : ""
    Local : Field : Cust Destination : Set as :""
    Local : Field : Cust Product : Set as : $EIStockItemName
    Local : Field : Cust Item Des : Set as : $CustBasicDes
    Local : Field : Custt Lenght : Set as : $CustALength
    Local : Field : Custt Width : Set as : $CustBWidth
    Local : Field : Custt Thickness : Set as : $CustCThickness
    Local : Field : Cust Net Qty : Set as : $SingleBilledQty
    Local : Field : Cust Gross Weight : Set as : ""
    Local : Field : Cust NoofPackets : Set as : ""

    Pls See the Code and guide me

    Thanks
    Rishi
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Show screenshot with exploded ...........
     


  5. Sarwan Kumar

    Sarwan Kumar New Member


    In which part you have define Repeat :LWDetailLine : collection There use Scroll and Remove Scroll in Exploded Part.

    Example :

    [Part : LWDetailLine]
    Line : LWDetailLine
    Repeat : LWDetailLine : LWDetailLineCollection
    Scroll : Vertical
    [Line : LWDetailLine]
    Field : LWDetailLineF1, LWDetailLineF2
    Right Field: LWDetailLineF3, LWDetailLineF4
    Explode : LWDetailLineExp : Yes

    [Part : LWDetailLineExp]
    Line : LWDetailLineExp
    Repeat : LWDetailLineExp : InventoryEntries

    [Line : LWDetailLineExp]
    Field : LWDetailLineExpF1, LWDetailLineExpF2
    Right Field : LWDetailLineExpF3, LWDetailLineExpF4
     


  6. Rishi kumar

    Rishi kumar Member


    Dear



    Dear Sir

    Earlier I have Used scroll now removed but nothing Happen.

    [Part:SLedDup_ReportsDescExp2]
    Line: Shipping Explode
    Repeat:Shipping Explode: InventoryEntries
    ;;Scroll:Vertical
     


  7. Rishi kumar

    Rishi kumar Member


    sir,
    pls see the screen shot
     

    Attached Files:



  8. Hems

    Hems Member


    Dear Rishi bhai
    आप जो चाहते है वो learn well यूट्यूब चैनल के इस वीडियो में है same to same
    आपका कोड भी इससे मिलता है, आपने शायद इसमे बदलाव किया है ।
    इसलिए पहले इस कोड को समझिये इसमें explode किस तरह use किया है ।

    शायद आपकी समस्या solve हो जाये

     


  9. Sarwan Kumar

    Sarwan Kumar New Member


    You have to share full code to understand the problem.

    Because Inventory Part Explode properly but Values is different.
     


  10. Sai Vineeth

    Sai Vineeth Active Member


    your report logic seems correct.
    Since you have custom methods like $CustALength,$CustBasicDes
    error can be collection.
    Without posting full code that helps to reproduce issue, it's hard for anyone to dig into problem.
    It's like giving half x-ray to doctor asking to diagnose.
     


  11. Rishi kumar

    Rishi kumar Member


    भाई सही हो गया
    मै ही गलती कर रहा था
    तुम कहाँ से हो ?
     


  12. Hems

    Hems Member


    I m from "Pali - Rajasthan"

    And

    सभी मेंबर्स और भाइयो को रक्षाबन्धन पर्व की हार्दिक शुभकामनाएं ।

    और धन्यवाद

    इस प्लेटफॉर्म पर हम जैसे नए मेंम्बर की tdl coding में मदद के लिए ।

    ,
     


  13. Rishi kumar

    Rishi kumar Member


    I m from prayagraj up.

    सब को रक्षा बंधन की हार्दिक शुभकामनाएँ ।
     


  14. Rishi kumar

    Rishi kumar Member


    एक नई query डाली है sales order se related .
    कुछ बताओ कैसे होगा ?
     


Share This Page