Dear,
I am using the Coding for Party Ledger, first i make View in SQL Server and then show on the Crystal Report but i am facing one Problem which is of Opening Balance, how shall i create opening Balance in Report, Kindly help me...
I am using this coding for Report.
crpled.ReportFi leName="D:\shan \Accounts\Repor ts\ledger.rpt"
crpled.Selectio nFormula = "{ledger.bcode} =" & Val(ac_code) & " and {ledger.vdate}> =#" & Format(dt1, "dd-mmm-yyyy") & "# and {ledger.vdate}< =#" & Format(dt2, "dd-mmm-yyyy") & "#"
crpled.Action = 1
Regards,
Muhammad Osama.
osama_is_cool@y ahoo.com
I am using the Coding for Party Ledger, first i make View in SQL Server and then show on the Crystal Report but i am facing one Problem which is of Opening Balance, how shall i create opening Balance in Report, Kindly help me...
I am using this coding for Report.
crpled.ReportFi leName="D:\shan \Accounts\Repor ts\ledger.rpt"
crpled.Selectio nFormula = "{ledger.bcode} =" & Val(ac_code) & " and {ledger.vdate}> =#" & Format(dt1, "dd-mmm-yyyy") & "# and {ledger.vdate}< =#" & Format(dt2, "dd-mmm-yyyy") & "#"
crpled.Action = 1
Regards,
Muhammad Osama.
osama_is_cool@y ahoo.com