Unable to export or Print - TCP file

Discussion in 'Tally.ERP 9' started by VipulM, Aug 7, 2019.

         
  1. VipulM

    VipulM New Member


    Hi there,

    I need to make in my Custom Dashboard
    Export and Print feature does not seem to work.
    At first the option itsef was not highlighted
    Then I tried adding the line below but it crashes with error saying "Software Exception 0xC0000005"

    Code:
    Button            : PrintButton, ExportButton
    Would be great if I could get help for the below code..
    Code:
    [#Menu:Gateway of Tally]
    
        Add : Key Item    : before : @@locQuit: User DashBoard    : O : Display      : EBDashBoard
    
    [Report:EBDashBoard]
        Form        :EBDashBoard
        Object        :Company
    
    [Form:EBDashBoard]
    Button            : PrintButton, ExportButton
        Width         :100% Page
        Part        :EBDashBoardMain
       
    [Part:EBDashBoardMain]
        Left Part    : EBDashBoardLeft
        Vertical    : No
       
    [Part:EBDashBoardLeft]
        Part    : EBDBCash
        Space Left    : 8 mm
        Space Right    : 8 mm
        Width        : 30% Page
        Vertical    : Yes   
    
    
    ;;======================== Top =======================
    [Part:EBDBCash]
        Use    : EBDBDefault Part
        Line    : EBDBCashTitle,EBDBCash,EBDBBank,EBDBHDFC,EBDBCashTot
       
    [Line:EBDBCashTitle]
        Field    : EBDBTitle Field
        Local    : Field    : EBDBTitle Field    : Set as    : "Cash & Bank"
       
    [Line:EBDBCash]
        Field    : EBDBLong Prompt,EBDBAmount Field
        Local    : Field    : Default        : Full Width: Yes
        Local    : Field    : EBDBLong Prompt    : Set as    : "Cash Balance:"
        Local    : Field    : EBDBAmount Field    : Set as    : @@CashBalance
        Local    : Field    : EBDBAmount Field    : Format    : "DrCr"
       
    [Line:EBDBBank]
        Field    : EBDBLong Prompt,EBDBAmount Field
        Local    : Field    : Default        : Full Width: Yes
        Local    : Field    : EBDBLong Prompt    : Set as    : "Bank Balance:"
        Local    : Field    : EBDBAmount Field    : Set as    : @@BankBalance
        Local    : Field    : EBDBAmount Field    : Format    : "DrCr"
    
    [Line:EBDBHDFC]
        Field    : EBDBLong Prompt,EBDBAmount Field
        Local    : Field    : Default        : Full Width: Yes
        Local    : Field    : EBDBLong Prompt    : Set as    : "HDFC Balance:"
        Local    : Field    : EBDBAmount Field    : Set as    : @@HDFCBalance
        Local    : Field    : EBDBAmount Field    : Format    : "DrCr"
    
    
    [Line:EBDBCashTot]
        Field    : EBDBLong Prompt,EBDBAmount Field
        Local    : Field    : Default        : Full Width: Yes
        Local    : Field    : EBDBLong Prompt    : Set as    : "Total:"
        Local    : Field    : EBDBAmount Field    : Set as    : If $$IsDr:@@BankBalance AnD $$IsDr:@@CashBalance then @@BankBalance+@@CashBalance else + @@CashBalance-@@BankBalance
        Local    : Field    : EBDBAmount Field    : Format    : "DrCr"
        Local    : Field    : EBDBAmount Field    : Border    : Totals
           
    ;===================== Defaults ==========================
    [Part:EBDBDefault Part]
        Space Bottom        : 5 mm
        Border            : Thin Box
        Width            : 25% Page
    
    [Field:EBDBTitle Field]
        Use        : Simple Field
        Align        : Center
        Width        : 100
        Style        : Normal Bold   
        Full Width    : Yes
        Background    : MenuTitleBGClr
        Color        : White
       
    [Field:EBDBMedium Prompt]
        Use            : Long Prompt
        Space Left        : 3 mm   
       
    [Field:EBDBLong Prompt]
        Align               : Prompt
        Width               : @@LongWidth+3
        Skip                : Yes
        Fixed               : Yes
       
    [Field:EBDBAmount Field]
        Use            : Amount Field
        Space Right        : 5 mm
       
    ;===================== System Formula ==========================
    
    [System:Formula]
        CashBalance    : $$NettAmount:($BSClosing:Group:"Cash-in-Hand"):($ForexClosing:Group:"Cash-in-Hand")
        BankBalance    : $$NettAmount:($BSClosing:Group:"Bank Accounts"):($ForexClosing:Group:"Bank Accounts")
        HDFCBalance    : $ClosingBalance:Ledger:"HDFC Bank Limited"
        LoanLiabiltyTot    : $$NettAmount:($BSClosing:Group:"Loans (Liability)"):($ForexClosing:Group:"Loans (Liability)")
        LoanAssetTot    : $$NettAmount:($BSClosing:Group:"Loans & Advances (Asset)"):($ForexClosing:Group:"Loans & Advances (Asset)")
        CashInFlowTot    : $CashInFlow:Company:##SVCurrentCompany
        CashOutFlowTot    : $CashOutFlow:Company:##SVCurrentCompany
        CapitalTotal    : $$NettAmount:($BSClosing:Group:"Capital Account"):($ForexClosing:Group:"Capital Account")
        FixedAssTotal    : $$NettAmount:($BSClosing:Group:"Fixed Assets"):($ForexClosing:Group:"Fixed Assets")
        SalesTotVal    : $ClosingBalance:Group:$$GroupSales
        PurchaseTotVal    : $ClosingBalance:Group:$$GroupPurchase
        GrossProfitTot    : $$AsPositive:$$Negative:$ClosingGrossProfit:Company:##SVCurrentCompany
        NetProfitTot    : $$AsPositive:$$Negative:$ClosingProfit:Company:##SVCurrentCompany
        OutstandingRec    : $$CollAmtTotal:NLCompanyReceivables:$ClosingBalance
        OutstandingPay    : $$CollAmtTotal:NLCompanyPayables:$ClosingBalance


    I basically want to have a dashboard where I can mention a group or a ledger (if I can add this via tally via a drop down list as well) the ledger names
     

    Attached Files:



  2. drive

    drive Member


    For , Print Remove this line
    Object : Company
     


  3. VipulM

    VipulM New Member


    Perfect! Worked great
     


  4. drive

    drive Member


    only alter mode we can use that object, no need in display mode.
     


Share This Page