[#Line :EI ColumnOne] Add : Right Fields : Before : VCH QtyTitle :VCH KGPunitTitle [Field : VCH KGPUnittitle] info : "Category" Width : 40 Style : Normal Bold Color : Red Inactive : Not @@IsSales [#Line: EI InvInfo] Add : Right Fields : Before : VCH BilledQty : SSVchTax [Field : SSVchTax] Use : Name Field Set as : $Category:Stockitem:$Stockitemname Storage : SSVchTax Width : 40 Skip : Yes ;Inactive : $$IsEnd:$StockItemName Inactive : Not @@IsSales Color : Red [System : UDF] SSVchTax : String : 5 [#Part: DB Columnar] Total : DBC LedAmt, DBC GrossAmt,EI AccAllocAmt, DBCAmount, DBC AddlCost, DBC Qty, DBC Revenue, DBC Cost, DBC Profit [#Line: DSP ColVchTitle] Add : Field : Fldarea Local: Field:fldArea:info:$$LocaleString:"Catagory" Local:Field:Align:Center Local : Field: Width: 20 [#Line: DSP ColVchDetail] add: Fields :fldArea [#Line: DSP ColVchDetailAlt] add: Fields :fldArea [Field:fldArea] Use : Namefield Set as: $SSVchTax Border: Thin Left Align: Left width :40 ;---------------- /* [#Line: DSP ColVchTotal] Use : DSP ColVchDetail Delete : Explode Delete : Empty Delete : Total Border : Flush Totals Space Top : if $$InPrintMode then 0.25 else 0 Fixed : Yes Local : Field : Default : Inactive: No Local : Field : DBC LedAmt : Set as : If $$IsRemoteCompany then @@AsLedColtotVal Else $$TotalBCLedAmt Local : Field : DBC Date : Set as : "" Local : Field : DBC Party : Set as : $$LocaleString:"Grand Total" Local : Field : DBC VchType : Set as : "" Local : Field : DBC VchNo : Set as : "" Local : Field : DBC BookName : Set as : "" Local : Field : DBC BookSlNo : Set as : "" Local : Field : DBCPartyExciseRegNo : Set as : "" Local : Field : DBC VchRef : Set as : "" Local : Field : DBC STNo : Set as : "" Local : Field : DBC ServiceTaxNo : Set as : "" Local : Field : DBC Narr : Set as : "" Local : Field : DBC ExciseRegNo : Set as : "" Local : Field : DBC PANNo : Set as : "" Local : Field : DBC CSTNo : Set as : "" Local : Field : DBC Qty : Set as : $$TotalBCQty Local : Field : DBC Rate : Set as : "" Local : Field : DBC GrossAmt : Set as : $$TotalBCGrossAmt Local : Field : EI AccAllocAmt : Set as : $$Total:amount Local : Field : DBC Amount : Set as : $$TotalBCAmount Local : Field : DBC AddlCost : Set as : $$TotalBCAddlCost Local : Field : DBC Revenue : Set as : $$TotalBCRevenue Local : Field : DBC Cost : Set as : $$TotalBCCost Local : Field : DBC Profit : Set as : $$TotalBCProfit /*
Dear Mr. Murli, Pls Try This . This Code is Prvoide by one of expert from forum. [#Part: DB Columnar] Total : DBC LedAmt, DBC GrossAmt,EI AccAllocAmt, DBCAmount, DBC AddlCost, DBC Qty, DBC Revenue, DBC Cost, DBC Profit [#Line: DSP ColVchTitle] Local:Field:fldArea:info:$$LocaleString:"Catagory" Local:Field:Align:Center Local : Field: Width: 20 [#Line: DSP ColVchDetail] add: Fields :Atend :fldArea [Field:fldArea] Use : Namefield Set as: $StockCatagoryName:Stock Item: $StockItemName Border: Thin Left Align: Left width :10 ;---------------- /* [#Line: DSP ColVchTotal] Use : DSP ColVchDetail Delete : Explode Delete : Empty Delete : Total Border : Flush Totals Space Top : if $$InPrintMode then 0.25 else 0 Fixed : Yes Local : Field : Default : Inactive: No Local : Field : DBC LedAmt : Set as : If $$IsRemoteCompany then @@AsLedColtotVal Else $$TotalBCLedAmt Local : Field : DBC Date : Set as : "" Local : Field : DBC Party : Set as : $$LocaleString:"Grand Total" Local : Field : DBC VchType : Set as : "" Local : Field : DBC VchNo : Set as : "" Local : Field : DBC BookName : Set as : "" Local : Field : DBC BookSlNo : Set as : "" Local : Field : DBCPartyExciseRegNo : Set as : "" Local : Field : DBC VchRef : Set as : "" Local : Field : DBC STNo : Set as : "" Local : Field : DBC ServiceTaxNo : Set as : "" Local : Field : DBC Narr : Set as : "" Local : Field : DBC ExciseRegNo : Set as : "" Local : Field : DBC PANNo : Set as : "" Local : Field : DBC CSTNo : Set as : "" Local : Field : DBC Qty : Set as : $$TotalBCQty Local : Field : DBC Rate : Set as : "" Local : Field : DBC GrossAmt : Set as : $$TotalBCGrossAmt Local : Field : EI AccAllocAmt : Set as : $$Total:amount Local : Field : DBC Amount : Set as : $$TotalBCAmount Local : Field : DBC AddlCost : Set as : $$TotalBCAddlCost Local : Field : DBC Revenue : Set as : $$TotalBCRevenue Local : Field : DBC Cost : Set as : $$TotalBCCost Local : Field : DBC Profit : Set as : $$TotalBCProfit /* if u satisfied then thanks to Admin who provide this platform..... Manish
pls see the postings, http://tdlexperts.com/index.php?threads/catagory-name-on-colmnar-register-reg.3785/ still if u face any problems, explain what is yr req.
sir, Yes Stil i am Facing the problem Please My Requirment this Report Please helme sir Thanks in advance