How to Collection of Group Please Guide?

Dear Sir

I want to learn how to collect as single group with amount
in my report.

please help me to create a new report.....

 

Respected sir my How to show report in t Formate

and second one how i can add formula for closing stock using op+pur+direxp-sale

[#Menu: gatewayoftally]
Add: Key Item: PL : 5 : Display: PL

[Report: PL]
Form: PL
Option: ALTER ON ENTER

[Form: PL]
Height: 100% page
Width: 100% page
Buttons : PrintButton, Change Period, ExplodeFlag,ChangeCompany
Part: TITLE PART
Left Part: LBODY PART
RIGHT Part: RBODY PART

BackGround : Light yellow
Space Top : If $$InPrintMode Then 0.5 Else 0 inches



[Part: TITLE PART]
Lines: COMNAME, COMADD ,PL , PARTILINE
Border: FULL



[Line: COMNAME]
Field: COMNAME
Space Top: 0

[Field: COMNAME]
Set as: @@CmpMailName
Align: Center
Full Width: YES

[Line: COMADD]
Field: COMADD
Space Top: 0

[Field: COMADD]
Set as: $$FullList:CompanyAddress:$Address
Align: Center
Full Width: YES

[Line: PL]
Field: MAINT
Space Top: .5


[Field: MAINT]
Set as: TRADING ACCOUNT
Align: Center
Full Width: YES

[Line: PARTILINE]
Field: LEFT LINE, RIGHT LINE
Space Top: 0

[Field: LEFT LINE]
Set as: "Particulars"
Border: THIN BOX
Alignment: Center
Full Width: Yes

[Field: RIGHT LINE]
Set as: "Particulars"
Border: THIN BOX
Alignment: Centre
Full Width: Yes

;;;;;;;;;;EXPENSE PART;;;;;;;;;;;;;;;;

[Part: LBodypart]
Height: 100 % PAGE
WidtH : 50% PAGE
Common Border: Yes

Parts: OPSTK ,PUR, DIREXP
Scrolled: Vertical

;;;;opening;;;;;;;

[Part:OPSTK]
Line: OPSTK


[ Line:OPSTK]
Field: OPSTKNAME
Field: OPSTK AMT

[Field: OPSTKNAME]
Set as: "Opening Stock"

[Field: OPSTK AMT]
Type: Amount
Set as: 25000


;;;;PURCHASE;;;;;;;

[PartUR]
Line: PUR
Repeat: PUR URCOLL

[ LineUR]
Field: PurName
Field: PurAmt

[FieldurName]
Type:String
Set as: $name



[FieldurAmt]
Type: Amount
Set as: $ClosingBalance
Format : "Symbol,DrCr"

[CollectionURCOLL]
Type: GROUP
child of: $$GroupPurchase
Belongs To: yes

;;;;DIRECT EXP;;;;;;;

[Partirexp]
Line: Direxp
Repeat: Direxp irexpCOLL

[ Lineirexp]
Field: DirexpName
Field: DirexpAmt

[FieldirexpName]
Type:String
Set as: $name

[FieldirexpAmt]
Type: Amount
Set as: $ClosingBalance
Format : "Symbol,DrCr"

[CollectionirexpCOLL]
Type : GROUP
child of: $$GroupDirectExpenses
Belongs To: yes

;;;;;;;;;;;;INCOME PART;;;;;;;;;;

[Part: RBodypart]
Height: 100 % PAGE
WidtH : 50% PAGE
Common Border: Yes

Parts: SALE, CLSTK
Scrolled: Vertical

[Part:SALE]
Line: SALE
Repeat: SALE :SALECOLL

[ Line:SALE]
Field: SALEName
Field: SALEAmt

[Field:SALEName]
Type:String
Set as: $name

[Field:SALEAmt]
Type: Amount
Set as: $ClosingBalance
Format : "Symbol,DrCr"

[Collection:SALECOLL]
Type : GROUP
child of: $$GroupSales
Belongs To: yes

;;;;;;CLOSING STOCK;;;;;;

[Part:CLSTK]
Line: CLSTK


[ Line:CLSTK]
Field: CLSTKNAME
Field: CLSTKAMT

[Field: CLSTKNAME]
Set as: "Closing Stock"

[Field: CLSTKAMT]
TYPE : Amount
SET AS: $$GroupDirectExpenses+$$GroupPurchase-$$GroupSales
Format : "Symbol,DrCr"

 

thank you very much for your support sir

Now only 3 problems i am facing with to final the p & l

1. Exclude the Zero balance Lines

2. Enter in Group Pressing Enter

3. In IndirectIncomeGroup Line showing Profit & Loss A/c

[Part:INDIC]
Line: INDIC
Repeat: INDIC :INDICCOLL

[Line:INDIC]
Field: INDICName
RIGHT Field: INDICAmt
Space Top: .5

Explode: DrillINDICItem :##ExplodeFlag OR $$KeyExplode

[Part: DrillINDICItem]
Line: DrillINDICItem
Repeat: DrillINDICItem : DrillINDICcoll
Local: Field: default :Style:Calibri Small Italic

[Line : DrillINDICItem]
Field: INDICName
RightField: INDICAmt
Indent: 2

[Field:INDICName]
Type:String
Set as: $name
Style: Calibri Default Bold

[Field:INDICAmt]
Type: Amount
Set as: $ClosingBalance
Style: Calibri Default Bold

[CollectionrillINDICcoll]
Type : LEDGER
child of: $$GroupIndirectIncomes
Belongs To: yes

[Collection:INDICCOLL]
Type: ledger
Child Of: $Name

 

RESPECTED SIR MY 3RD PROBLEM SOLVED

1ST 2 PROBLEM AR STANDS AS IT IS

 

thank you sir for your support
i will try the way that you suggested me.....

thank you