Help Me on Making Report

Dear Admin Sir & Members,

i Tries to create a report of sale order but facing some issue. Pls help me.

In below report in order amount field i want sale order total Amount Encl Tax & other charges.
Also when press enter respective voucher open (Alter).

Thanks & Regards,

Mani

[Form : SaleOrders Detail]
Use : DSP Template
Space Bottom : 0.4
Space Top : 0.5
Space Left : 0.5
Space Right : 0.5
Full Height : Yes
Full Width : Yes
Full Object : Yes
Part : Orders Bills and payrec
Set Always : SVPrintOrientation: $$SysName:Landscape
Button : Select Company,Close Company,Change Company,Change Period,Print Button,Export Button
Background : Lily Yellow

[Part : Orders Bills and payrec]
Line : Orders Bills and payrec Title, Orders Bills and payrec Led, Orders Bills and payrec Total Line

Repeat : Orders Bills and payrec Led: CFBK Summ Voucher ;;My Collection

Scroll : Vertical
;;Total : Sale Order Value, Sale Value

[Line : Orders Bills and payrec Title]
Use : Orders Bills and payrec Led
Border : Column Titles
Local : Field : SNo : Info : "S. No."
Local : Field : Party Ledger : Info : "Ledger Name"
Local : Field : Party Orderno : Info : "Order No."
Local : Field : Party Orderdt : Info : "Order Date"
Local : Field : Party Orderamt: Info : "Order Amount"
Local : Field : Party Ordersale: Info : "Sale Amount Against Order"
Local : Field : Party Ordersale: Lines: 2
Local : Field : Party Orderrec: Info : "Payment Received Against Order"
Local : Field : Party Orderrec: Lines : 2
Local : Field : Party Balance : Info : "Balance"
[Line : Orders Bills and payrec Led]
Field : SNo
Right Fields : Party Orderdt,Party Orderno,Party Ledger,Party Orderamt,Party Ordersale,Party orderrec,Party Balance

[Field : SNo]
Use : Simple Field
Set as : $$Line
Border : Thin Left
Style : Small Bold
Align : Center
Width : 5

[Field : Party Ledger]
;;Use : Name Field
Set as : $PName ;;"Party Ledger Name"
Align : Left
Border : Thin Left
Style : Small Bold
Width : 36+9+9
[Field : Party Orderno]
;;Use : Name Field
Set as : $OrNo
Align : Left
Border : Thin Left
Width : 9+9
[Field : Party Orderdt]
Use : Date Field
Set as : $SORDT ;;Date,Reference
Align : Left
Border : Thin Left
Width : 9+9
[Field : Party Orderamt]
Use : Amount Field
Set as : $Amount
Align : Left
Border : Thin Left
Width : 9+9
[Field : Party ordersale]
Use : Name Field
Set as : ""
Align : Left
Border : Thin Left
Width : 9+9
[Field : Party orderrec]
Use : Name Field
Set as : ""
Align : Left
Border : Thin Left
Width : 9+9
[Field : Party Balance]
Use : Name Field
Set as : ""
Align : Left
Border : Thin LeftRight
Width : 9

[Line :Orders Bills and payrec Total Line]
Use : Orders Bills and payrec Led
Border : Column Titles
Local : Field : SNo : Info : ""
Local : Field : Party Ledger : Info : ""
Local : Field : Party Orderno : Info : ""
Local : Field : Party Orderdt : Info : ""
Local : Field : Party Orderamt: Info : ""
Local : Field : Party Ordersale: Info : ""
;;Local : Field : Party Ordersale: Lines: 2
Local : Field : Party Orderrec: Info : ""
;;Local : Field : Party Orderrec: Lines : 2
Local : Field : Party Balance : Info : ""
;;===================================
[Collection: My Collection]
Type: Ledger
Child Of: $$GroupSundryDebtors
;;Show all the Ledgers falling under Group "Sundry Debtors" or its sub-groups
BelongsTo: Yes

[Collection: DWKORDER Voucher] ;;CFBK Voucher
Type : Vouchers : VoucherType
Child of : $$VchTypeSalesOrder
Belongs To : yes
Fetch : Date,Reference,order Number,Amount,Inventory Entries

;;===================================
[Collection: CFBK Summ Voucher]
Source Collection : DWKORDER Voucher
Walk : Inventory Entries
By : PName : $PartyLedgerName
By : IName : $StockItemName
By : OrNo : $Reference
By : SORDT : $Date
By : SORTOTAMT : $EIValue

Aggr Compute : BilledQty : SUM : $BilledQty
Aggr Compute : Amount : SUM : $Amount ;;I WANT SALE ORDER TOTAL AMOUNT
Search Key : $OrNo ;;$IName + $PName

 

You should explore collection of Report:
Pending Sales Order

 

Dear Himanshu ji,

As above required in the respective code i already getting sales order collection but not success. can you pls modify as per your suggestion.
your help will increase my knowledge.

Thanks & Regards,

Mani

 

Sir I understand, That Sales Order is coming but to get Sales Amount.. You should get Sales Order Data From that collection only else Fetching Sales Amount will be headache

Type of Collection Would be Sales Order As far as I remember

Sample Collection:
[Collection: Sales Order Uncleared]
Type: Sales Order
Fetch:*, *.*

/*
Reference = $Name
Pending Qty = $ClosingBalance
Stock Item Name = $Parent
*/

You can explore more methods by searching for similar collection with type: Sales Order