DEAR SIR, I AM TRYING TO CREATE A REPORT WITH STOCK ITEM NAME WITH MULTIPLE BATCHES , CLOSING VALUE. HAVE TRIED THE ATTACHED CODE BUT MULTIPLE ACTIVE BATCH IS NOT ABLE TO REFLECT IN SUMMARY REPORT. PLEASE HELP TO RECTIFY ERROR . [#Menu: Gateway of Tally] ;; BUTTOM ADDED ON MAIN GATEWAY Add: Item: Grp Report : Display: Smpl Stk Grp Rep [Report: Smpl Stk Grp Rep] Form : Smpl Stk Grp Rep Use : Dsp Template Title : "Stock Group Report" Variable: ExplodeFlag, Stock Group Name [Form: Smpl Stk Grp Rep] Part : Smpl Stk Grp Rep ;Background : White, Light Orange Button : Change Period, Print Button, Explode Flag Keys : Form Remove Line, Form Show Last Removed Line Button : BtnGroup Height : 100 % Screen Width : 100 % Screen [Part: Smpl Stk Grp Rep] ;; TITLE OF THE REPORT Parts : Form SubTitle, Smpl Stk Grp Rep Details Local : Field : Form SubTitle : Set as : "Stock Group Report For the Period " + @@DspDateStr Vertical: Yes [Part: Smpl Stk Grp Rep Details] Lines : Smpl Stk Grp Rep Title, Smpl Stk Grp Rep Details Bottom Line : Smpl Stk Grp Rep Total Repeat : Smpl Stk Grp Rep Details : Smpl Stk Grp and Item Coll Total : MyField1, Smpl Stk Grp Rep Item Qty, Smpl Stk Grp Rep Item Value Scroll : Vertical [Line: Smpl Stk Grp Rep Details] Fields : Smpl Stk Grp Rep Item Name, MyField1 Right Field : Smpl Stk Grp Rep Item Qty, Smpl Stk Grp Rep Item Value Explode : Smpl Stk Grp Item Details : $$IsStockGroup AND (##ExplodeFlag OR $$KeyExplode) Option : Smpl IsStock Item : $$IsStockItem Space Bottom: 2 mms [!Line: Smpl IsStock Item] ;Local : Field : Default : Style : Normal Italic Local : Field : Default : Color : Blue [Part: Smpl Stk Grp Item Details] LinE : Smpl Stk Grp Item Details Repeat : Smpl Stk Grp Item Details : Smpl Stk Grp and Item Coll [Line: Smpl Stk Grp Item Details] Use : Smpl Stk Grp Rep Details [Line: Smpl Stk Grp Rep Total] Use : Smpl Stk Grp Rep Details Local : Field : Default : Type : String Local : Field : Smpl Stk Grp Rep Item Name : Align : Center Local : Field : Smpl Stk Grp Rep Item Name : Set As : "Total" Local : Field : MyField1 : Set as : $$Total:MyField1 Local : Field : Smpl Stk Grp Rep Item Qty : Set As : $$Total:SmplStkGrpRepItemQty Local : Field : Smpl Stk Grp Rep Item Value : Set As : $$Total:SmplStkGrpRepItemValue Border : Totals [Line: Smpl Stk Grp Rep Title] Use : Smpl Stk Grp Rep Details Local : Field : Default : Type : String Local : Field : Smpl Stk Grp Rep Item Name : Align : Center Local : Field : Smpl Stk Grp Rep Item Name : Set As : "Particulars" Local : Field : EPBATCHNAME : Set as : "Batch Name" Local : Field : MyField1 : Set as : "Opening Balance" Local : Field : Smpl Stk Grp Rep Item Qty : Set As : "Closing Balance" Local : Field : Smpl Stk Grp Rep Item Value : Set As : "Closing Value" Border : Column Titles [Field: EPBATCHNAME] Use: Name Field Set As : $BatchName Align : Center Width : 20 [Field: Smpl Stk Grp Rep Item Name] Use : Name Field Set As : $Name Option : Smpl Stk Grp Item Name : $$IsStockItem Option : Smpl Stk Grp Name : $$IsStockGroup Color: Green [!Field: Smpl Stk Grp Name] Variable: Stock Group Name Display : Smpl Stk Grp Rep Alter : Stock Group Variable: StockGroupName Color : Red [!Field: Smpl Stk Grp Item Name ] Variable: Stock Item Name Display : Item Monthly Summary Alter : Stock Item [Field: MyField1] Use: Number Field Set as: $IntQtyOpBal Color: Red [Field: Smpl Stk Grp Rep Item Qty] ;Use : Qty Primary Field ;Type: Number: Forced ;Set Always: Yes Width : @@NameWidth Set As : $ClosingBalance Color : REd [Field: Smpl Stk Grp Rep Item Value] Use : Amount Field Width : @@NameWidth Set As : $ClosingValue Color : REd [Collection: Smpl Stk Grp and Item Coll] Collection : Smpl Stk Grp Coll, Smpl StkGrp Items [Collection: Smpl Stk Grp Coll] Type : Stock Group ;Child Of: #StockGroupName Fetch : Name, BATCHNAME, Closing Balance, Closing Value Filter : RDGroupOnly [Collection: Smpl StkGrp Items] Type : Stock Item Childof : #StockGroupName Fetch : Name, BATCHNAME, Closing Balance, Closing Value Compute : IntQtyOpBal :$$AsSignedQty:$$GodownItemValue@IntFGPET:$StockItemName:$OpeningBalance [System: Formula] IntFGPET : "Finished Good PET";"Finished Goods - Int" RDGroupOnly:if ##isRDGrpName contains "All Item" then $Name contains "" else $Name = ##isRDGrpName [Button:BtnGroup] Key:F5 Action:Alter:BtnGroup Title:Group Wise [Report:BtnGroup] Form:BtnGroup [Form:BtnGroup] Part:BtnGroup No Confirmation:Yes [Part:BtnGroup] Line:BtnGroup [Line:BtnGroup] Field:Medium Prompt,BtnGroup Local:Field:Medium Prompt:Set as:"Select Group" Local:Field:Medium Prompt:Style:Normal Bold Local:Field:Medium Prompt:Color:RED [Field:BtnGroup] Use:Name Field Variable:isRDGrpName Modifies:isRDGrpName Set Always:Yes Table:GrpFilter,allitems,EndOfList Show Table:Always Width:40 Border:thinbox [System:variable] isRDGrpName:"" [Variable:isRDGrpName] Type:String [Collection:GrpFilter] Title:"List of Group (Please Select)" + " Closing Value" Type:Stock Group Belongs To:Yes Report:Smpl Stk Grp Rep Fetch:Name, Parent, IsDeemedPositive Format:$$Name, 30 Format:$ClosingValue, 10 Set as:$Name Fetch: SortPosition, AdditionalName Is ODBC Table:Yes
