hello members, I stuck in a columnar report. Below is my report: My Columns are repeating. In sales row, collection is holding same value for all columns. In the field level i call a function: [Field : CCSalesAmt] Use : Amount Field Set as : $$GetGdwnStkGrpBal$DepartGodown:costcentre:##CostCentre) [Function : GetGdwnStkGrpBal] Parameter : varLocation : String Variable : varVal : Amount Return : Amount 100 : Set : varVal : $$CollAmtTotal:GroupInGodownNameNew:$ConsumtionVal 110 : Return : ##varVal [Collection: GroupInGodownNameNew] ;ParmVAR : pvsGodownName : String : ##varLocation Source Collection : GroupInGodownNameSmmry Fetch : Name, Closing Rate, Opening Balance, Opening Value, Opening Rate,+ Inward Quantity, Outward Quantity, Inward Value, Outward Value, TBalOpening,TBalDebits,TBalClosing Compute : ConsumtionVal : ($$NettAmount:$TBalOpening:$$NettAmount:$TBalDebits:$$Negative:$TBalClosing) [Collection: GroupInGodownNameSmmry] Parm Var : SVFromDate : Date : ##SVFromDate Parm Var : SVToDate : Date : ##SVToDate ; Compute Var : pvsGodownName : String : ##varLocation ParmVAR : pvsGodownName : String : ##varLocation;SVTestGdwnName;varLocation;$DepartGodown:costcentre:##CostCentre Type : Stock Groups in Godown Child of : ##pvsGodownName ; Filter : ChildOfStockGroupName ;ParmVAR : pvsGodownName : String : $DepartGodown:costcentre:##CostCentre;@@RMGdwn;"Bakery Raw Material";If $$ExplodeLevel=0 AND $IsStockGroup Then ##DSPGodownName Else + ;If $$IsEmpty:$GodownName Then #DSPGodownName Else $GodownName ; ParmVAR : StkGroupName : String : $$FieldVar:StockGroupName Fetch : Name, Closing Rate, Opening Balance, Opening Value, Opening Rate,+ Inward Quantity, Outward Quantity, Inward Value, Outward Value, AddlOutwardValue Compute : IsGodown : $$IsGodown Compute : IsStockGroup : $$IsStockGroup Compute : IsStockItem : $$IsStockItem Compute : IsEmptyObject : $$IsEmptyObject Compute : NumChildren : $$NumChildren Compute : Alias : $$Alias Compute : PNAlias : "" Compute : StkClBalance : If $$IsEmpty:$$AsSignedQty:$$GodownGroupValue:##pvsGodownName:$Name:$ClosingBalance Then 0 Else $$AsSignedQty:$$GodownGroupValue:##pvsGodownName:$Name:$ClosingBalance Compute : StkOpBalance : If $$IsEmpty:$$AsSignedQty:$$GodownGroupValue:##pvsGodownName:$Name:$OpeningBalance Then 0 Else $$AsSignedQty:$$GodownGroupValue:##pvsGodownName:$Name:$OpeningBalance Compute : TBalClosing : If $$IsEmpty:$$AsSignedQty:$$GodownGroupValue:##pvsGodownName:$Name:$ClosingValue Then 0 Else $$AsSignedQty:$$GodownGroupValue:##pvsGodownName:$Name:$ClosingValue Compute : TBalOpening : If $$IsEmpty:$$AsSignedQty:$$GodownGroupValue:##pvsGodownName:$Name:$OpeningValue Then 0 Else $$AsSignedQty:$$GodownGroupValue:##pvsGodownName:$Name:$OpeningValue Compute : StkInQty : If $$IsEmpty:$$AsInQty:$$GodownGroupValue:##pvsGodownName:$Name:$InwardQuantity Then 0 Else $$AsInQty:$$GodownGroupValue:##pvsGodownName:$Name:$InwardQuantity Compute : StkOutQty : If $$IsEmpty:$$AsOutQty:$$GodownGroupValue:##pvsGodownName:$Name:$OutwardQuantity Then 0 Else $$AsOutQty:$$GodownGroupValue:##pvsGodownName:$Name:$OutwardQuantity Compute : TBalCredits : If $$IsEmpty:$$AsOutQty:$$GodownGroupValue:##pvsGodownName:$Name:$OutwardValue Then 0 Else $$AsOutQty:$$GodownGroupValue:##pvsGodownName:$Name:$OutwardValue Compute : TBalNettCredits: If $$IsEmpty:$$AsOutQty:$$GodownGroupValue:##pvsGodownName:$Name$$AmountSubtract:$OutwardValue:$AddlOutwardValue) Then 0 Else $$AsOutQty:$$GodownGroupValue:##pvsGodownName:$Name$$AmountSubtract:$OutwardValue:$AddlOutwardValue) Compute : TBalDebits : If $$IsEmpty:$$AsInQty:$$GodownGroupValue:##pvsGodownName:$Name:$InwardValue Then 0 Else $$AsInQty:$$GodownGroupValue:##pvsGodownName:$Name:$InwardValue Compute : IsWithItems : Yes Compute : IsWithVouchers : Yes Compute : GodownName : ##pvsGodownName Kindy me members.
