Dear Experts, I am trying to get Report based on Budget Allocations. Reports are getting through Attached codes, Only one issue Just not getting Budget Name in Report. Anyone can help? Thank you Code: [#Menu : GateWay Of Tally] Add : Item : Before : @@locDisplay : test:Display: Custom Budget Reports [Report:Custom Budget Reports] Form: ShowBudget [Form: ShowBudget] Part: ShowBudgetBody [Part: ShowBudgetBody] Lines: ShowBudgetTitle, ShowBudgetBody Repeat:ShowBudgetBody: BudgetPeriodcoll ;BudgetLedgercoll ;BudgetPeriodcoll ;BudgetLedgercoll ;BudgetPeriodcoll ;detailBudgetcoll Scroll: Vertical [Line: ShowBudgetTitle] Field: short Name Field, STARTINGFROMs, ENDINGATs, Name Field, Amount Field Local: Field: Name Field: Set as:"LedgerName" Local: Field: Amount Field: Set as:"Amount" Local: Field: Default: Type: String Local: Field: short Name Field: Set as:"BudgetName" Local: Field: ENDINGATs: Set as:"ENDINGAT" Local: Field: STARTINGFROMs: Set as:"STARTINGFROM" [Line: ShowBudgetBody] Field: short Name Field, STARTINGFROMs, ENDINGATs, Name Field, Amount Field Local: Field: Name Field: Set as:$LedgerName Local: Field: Amount Field: Set as:$Amount Local: Field: short Name Field: Set as:$xName Local: Field: ENDINGATs: Set as:$ENDINGAT Local:Field:STARTINGFROMs:set as:$STARTINGFROMs [Field: ENDINGATs] Use: Uni date Field [Field:STARTINGFROMs] Use: uni date field [Collection: CombineBudgetColl] Source Collection:BudgetPeriodcoll, BudgetLedgercoll By : Name: $Name By : LedgerName:$Name By : ENDINGAT:$ENDINGAT By : STARTINGFROMs:$STARTINGFROM ; Compute : ENDINGAT:$ENDINGAT ; Compute : STARTINGFROMs:$STARTINGFROM Aggr Compute : Amount : Sum : $$AsAmount:$Amount [Collection: Budgetcoll] Type : Budget Fetch : Name Format : $Name,30 [Collection : BudgetPeriodcoll] Source Collection: Budgetcoll Walk : Budget Periods, ACCOUNTINGALLOCATIONS By : xName: $Name By : LedgerName:$Name By : ENDINGAT:$ENDINGAT By : STARTINGFROMs:$STARTINGFROM ; Compute : ENDINGAT:$ENDINGAT ; Compute : STARTINGFROMs:$STARTINGFROM Aggr Compute : Amount : Sum : $$AsAmount:$Amount Fetch : Name,StartingFrom, ENDINGAT ; [Collection : BudgetLedgercoll] Source Collection: BudgetPeriodcoll Walk : Budget Periods, ACCOUNTINGALLOCATIONS By : Name: $xName By : LedgerName:$Name ; By : ENDINGAT:$ENDINGAT ; By : STARTINGFROMs:$STARTINGFROM ; Compute : ENDINGAT:$ENDINGAT ; Compute : STARTINGFROMs:$STARTINGFROM Aggr Compute : Amount : Sum : $$AsAmount:$Amount Fetch : Name,StartingFrom, ENDINGAT
;;Try this code [#Menu : GateWay Of Tally] Add : Item : Before : @@locDisplay : testisplay: Custom Budget Reports [Report:Custom Budget Reports] Form: ShowBudget [Form: ShowBudget] Part: ShowBudgetBody [Part: ShowBudgetBody] Lines: ShowBudgetTitle, ShowBudgetBody Repeat:ShowBudgetBody: BudgetPeriodcoll ;BudgetLedgercoll ;BudgetPeriodcoll ;BudgetLedgercoll ;BudgetPeriodcoll ;detailBudgetcoll Scroll: Vertical [Line: ShowBudgetTitle] Field: short Name Field, STARTINGFROMs, ENDINGATs, Name Field, Amount Field Local: Field: Name Field: Set as:"LedgerName" Local: Field: Amount Field: Set as:"Amount" Local: Field: Default: Type: String Local: Field: short Name Field: Set as:"BudgetName" Local: Field: ENDINGATs: Set as:"ENDINGAT" Local: Field: STARTINGFROMs: Set as:"STARTINGFROM" [Line: ShowBudgetBody] Field: short Name Field, STARTINGFROMs, ENDINGATs, Name Field, Amount Field Local: Field: Name Field: Set as:$LedgerName Local: Field: Amount Field: Set as:$Amount Local: Field: short Name Field: Set as:$xName Local: Field: ENDINGATs: Set as:$ENDINGAT Local:Field:STARTINGFROMs:set as:$STARTINGFROMs [Field: ENDINGATs] Use: Uni date Field [Field:STARTINGFROMs] Use: uni date field [Collection: CombineBudgetColl] Source Collection:BudgetPeriodcoll, BudgetLedgercoll By : Name: $Name By : LedgerName:$Name By : ENDINGAT:$ENDINGAT By : STARTINGFROMs:$STARTINGFROM ; Compute : ENDINGAT:$ENDINGAT ; Compute : STARTINGFROMs:$STARTINGFROM Aggr Compute : Amount : Sum : $$AsAmount:$Amount [Collection: Budgetcoll] Type : Budget Fetch : Name Format : $Name,30 [Collection : BudgetPeriodcoll] Source Collection: Budgetcoll Walk : Budget Periods, ACCOUNTINGALLOCATIONS By : xName: $..Name By : LedgerName:$Name By : ENDINGAT:$ENDINGAT By : STARTINGFROMs:$STARTINGFROM ; Compute : ENDINGAT:$ENDINGAT ; Compute : STARTINGFROMs:$STARTINGFROM Aggr Compute : Amount : Sum : $$AsAmount:$Amount Fetch : Name,StartingFrom, ENDINGAT ; [Collection : BudgetLedgercoll] Source Collection: BudgetPeriodcoll Walk : Budget Periods, ACCOUNTINGALLOCATIONS By : Name: $xName By : LedgerName:$Name ; By : ENDINGAT:$ENDINGAT ; By : STARTINGFROMs:$STARTINGFROM ; Compute : ENDINGAT:$ENDINGAT ; Compute : STARTINGFROMs:$STARTINGFROM Aggr Compute : Amount : Sum : $$AsAmount:$Amount Fetch : Name,StartingFrom, ENDINGAT