Explode not working

admin sir ,
please replay my file with Suggestions as per our chat yesterday
there is explode is not working in my report

 

Where is the file

 

this is the file

 

Please Upload the data also.

 

Respected Umesh

U have written
Explode : AgentForm : ##ExplodeFlag or $$KeyExplode
this only, but to explode now u hv to write a Part named AgentForm i.e.

[Part : AgentForm]
Line: abc
Repeat : Abc : InventoryEntries
Scroll: Vertical
[Line: Abc]
Field: AbcItemName, AbcBilledQty, AbcRate, AbcAmt

Then define the fields and setas the appropriate values.

then try.

Plz revert back, is it helps.

 

please see below code tally goes hangs out to end task

[#Menu: Account Statements]

Add: Key Item: Before: @@locquit: Agent Wise Commision: W: Display Collection: AgentWiseSaleReport

[Report: AgentWiseSaleReportSel]
Use : Collection Variable
Local : Line : Collection Variable : Field : AgentWiseSaleReport
Local : Field: MV Title : Info : $$LocaleString:"Select Name of Agent "
Replace : Set : SV From Date : SV From Date : $$MonthStart:##SVCurrentDate
Replace : Set : SV To Date : SV To Date : $$MonthEnd:##SVCurrentDate

[Field: AgentWiseSaleReport]
Use : Name Field
Table : AgentWiseSaleReport
Show Table : Always
Modifies : LedgerName

[Report: AgentWiseSaleReport]
Form : AgentForm

[Form : AgentForm ]

Buttons : ExplodeFlag,ChangeDybkDate,ChangePeriod
BottomButton: BlankButton, RelReports, InvReports, AcctReports, Report Operations, StatRegConfigure, FilterButton, ValueButton
Buttons : PrintButton, ExportButton, UploadButton, MailButton
Bottom Toolbar Buttons : BottomToolBarBtn1, BottomToolBarBtn2_EditVch, BottomToolBarBtn3, BottomToolBarBtn4, BottomToolBarBtn5, BottomToolBarBtn6, BottomToolBarBtn7, BottomToolBarBtn8, BottomToolBarBtn9, BottomToolBarBtn10, BottomToolBarBtn11, BottomToolBarBtn12
Top Part :MainTitle
Part : AgentForm
Option : SmallWidthForm : $$InPrintMode
Option : SmallSizeForm : NOT $$InPrintMode

[Part : MainTitle]
Top Lines : MainTitle
Space Bottom : 1
Space Top : 1
Border : Thin Box

[Part : AgentForm]

Line: Agent Titles, Party Details
Bottom Lines : COlTotals
Repeat : Party Details : AgentWiseSaleReportColl
Scroll: Vertical
Common Border : Yes
Total :AmtWTax, AmtWOTax,Total,Brokrage,Qty,AltQty



[line:MainTitle]

Field arty NameF
Right Field : MainDateTitle
Local : Field : Party NameF : Set as : $$LocaleString:"Broker Name : " +$Name:Ledger:#LedgerName
Local : Field : Default : Object : Ledger : #LedgerName
Local : Field : MainDateTitle :Set as : @@DSPDateStr
Local : Field : Default : Style : Normal Bold

[Field: MainDateTitle]

Use : Name Field
Style : Normal Bold
Align : Right
Skip : Yes
Cells : 5


[Field : Party NameF]

Align : Center
Width : 25

[Line :Agent Titles]

Use : Party Details
Local : Field : Vouchar Date: Set as: "Date"
Local : Field : Party Name: Set as: "Party Name"
Local : Field : VCHRefno : Set as : "Bill No"
Local : Field : Vouchar : Set as: "Vouchar"
Local : Field : AmtWTax : Set as: "Tax Amount"
Local : Field : AltQty : Set as: "Atl. Quantity"
Local : Field : Qty : Set as: "Quantity"
Local : Field : AmtWOTax: Set as: "Value"
Local : Field : Total : Set as: "Total"
Local : Field : Brokrage: Set as: "Brokrage"
Local : Field : Default : Align : Centre
Local : Field : Default : Style : Normal Bold
Local : Field : Default : Color : Blue
Local : Field : Default :Type : String
Border: Thin Top Bottom

[Line: Party Details]

Field : Vouchar Date,Party Name
Right Fields: VCHRefno,Vouchar, AmtWTax, AmtWOTax,Total,Brokrage,AltQty,Qty
Option : Alter on enter
Option : DisplayOnAltEnter
Explode : AgentForm : ##ExplodeFlag or $$KeyExplode

 

Sir,

You had exploded the line and used the parent part, which is INFINITE LOOP.
So you have to change the exploded part name, and define it separately.
by defining line which will repeat over inventory entries.
and then setas the values.

Hope it will clear it. Plz revert back.

 

I m talking about below: -

[Line: Party Details]
Field : Vouchar Date,Party Name
Right Fields: VCHRefno,Vouchar, AmtWTax, AmtWOTax,Total,Brokrage,AltQty,Qty
Option : Alter on enter
Option : DisplayOnAltEnter
Explode : AgentForm : ##ExplodeFlag or $$KeyExplode

This Explode : AgentForm : ##ExplodeFlag or $$KeyExplode
creates problems as this part name is used before which is the parent part for this line, so going in infinite loop.

 

[Part: My TB Inv Explosion]
Lines : My TB Inv Explosion
Repeat : My TB Inv Explosion : Invnetory Entries
Scroll : Vertical

[Lines : My TB Inv Explosion]
Field Lines : My TB Inv ExplosionItem ;; here add other fields

[Field: My TB Inv ExplosionItem]
USe : Name field
Set as $StockItemName

 

Plz use this

 

thanks mr girdhar got it i was place explode in wrong line so now its working thanks again sir

 

most welcome
thnx to admin