How can get party wise sub total after sorting report

I think you are exporting instead of using "Print to PDF"

Tally Export Functionality doesn't work well with Colours

 

Thanks sir ji
As your suggestion
Landscape colourful export pdf coming

 

Sir,
why is there a gap in the beginning of 2,3,4 pages in export or print ?

 

In my code

I have not mentioned the word "particulars"
anywhere in my code.

Then why it comes ?

 

Dear sir,
I want to sort a column which gets its value from another field. Is it possible to sort according to that new column and get sub total of new column ?



Full Code :
[#Menu:Gateway of Tally]
Add: Item: My Sale Report: Display: SVR SalesReport

[Report: SVR SalesReport]

Form: SVR SalesReport

Title:"SALES ENTRIES"
Variable : SVFromDate,SVToDate, hksort
Set : SVFromDate : $$MonthStart:##SVFromDate
Set : SVToDate : $$MonthEnd:##SVCurrentDate

[Form: SVR SalesReport]
Use : DSP Template
Button:sortreport
Height:100% Page
Width:100 % Page
Background:White

Part:SVR MenuTitlePart, SVR menuDTpart

[Part: SVR MenuTitlePart]
Line: SVR MenuTitlePart
Border: thin Top Bottom
Background: Pale Sea Green

[Line: SVR MenuTitlePart]
Field: SVR SnoTitle1, SVR DateTitle1, SVR VchNoTitle1, SVR PartyNameTitle1, SVR PartyNameToSort
Right Field: SVR AmountTitle1
Local : Field : Default : Type : String
Local : Field : Default : Style : Normal Bold
Local : Field : SVR SnoTitle1 : Set as : "S.No"
Local : Field : SVR DateTitle1 : Set as : "Date"
Local : Field : SVR VchNoTitle1 : Set as : "Vch"
Local : Field : SVR VchNoTitle1 : Color : "black"
Local : Field : SVR PartyNameTitle1 : Set as : "PartyName"
Local : Field : SVR PartyNameToSort : Set as : "PartyName to Sort"
Local : Field : SVR Amount Title1 : Set as : "Amount"


[Field: SVR SnoTitle1]
Use:Number Field
Width:3% page
Align:Center

[Field: SVR DateTitle1]
Use : Short Date Field
Width:5% page
Align:Right

[Field: SVR VchNoTitle1]
Use:Number Field
Width: 5% page
Align:Center

[Field: SVR PartyNameTitle1]
Use: Name Field
Width: 25% page
Align:Left

[Field: SVR PartyNameToSort]
Use: Name Field
Width: 25% page
Align:Left

[Field: SVR AmountTitle1]
Use: Amount Field
Width: 10% page
Align: Right

;*=====Details Recprd-===*/
[Part:SVR menuDTpart]
Line : SVR MenuDetailsPart
Border : thin Bottom
Repeat : SVR MenuDetailsPart: sort Coll AllSalesVch ;for allsalesvoucher
Scroll : Vertical
common border : yes
total : SVRAmountTitle

[Line: SVR MenuDetailsPart]
Field: SVR SnoTitle, SVR DateTitle, SVR VchNoTitle, SVR PartyNameTitle, SVR PartyNameToSort2
Right Field: SVR AmountTitle
Option: display on enter

Explode:hkspartywisetotal: $$nextObj:$partyledgername!=$partyledgername OR $$IslastObj
Explode:hkspartywisetotal2: $$IslastObj

[Part:hkspartywisetotal]
Line: hkspartywisetotal

[Part:hkspartywisetotal2]
Line: hkspartywisetotal

[Line :hkspartywisetotal]
Field: SVR SnoTitle, SVR DateTitle, SVR VchNoTitle, SVR PartyNameTitle, SVRDummy
Right Field: SVR AmountTitle
local : field : SVR AmountTitle : set as : $$FilterAmtTotal:LedgerwiseTotals:TotFltr:$TotalSale
Local : Field : default : color : blue
Local : Field : SVR SnoTitle : Set as: ""
Local : Field : SVR SnoTitle : Type:String
Local:Field: SVR DateTitle:Set as: ""
Local:Field: SVR VchNoTitle: Set as: ""
Local:Field: SVR VchNoTitle: Type:String
;Local:Field: SVR PartyNameTitle: Set as: "totalallal"
Local:Field: SVR PartyNameTitle: Type:String
Local:Field: SVR PartyNameTitle: Invisible : yes

[Field : SVRDummy]
Use : SVR PartyNameTitle
Set As : "TOTAL"


[System : Formula]
TotFltr : #SVRPartyNameTitle = $partyledgername


[Field: SVR SnoTitle]

Use:Number Field
Style:Normal Bold
Width:3% page
Align:Center
Set as:$$Line

[Field: SVR DateTitle]

Use : Short Date Field
Style:Normal Bold
Width:5% page
Align:Right
Set as:$date

[Field: SVR VchNoTitle]

Use:Number Field
Style:Normal Bold
Width: 5% page
Align:Center
Set as:$vouchernumber

[Field: SVR PartyNameTitle]

Use: Name Field
Style: Normal Bold
Width: 25% page
Align:Left
Set as:$partyledgername
Variable: LedgerName
Display : Ledger Vouchers

[Field: SVR PartyNameToSort2]
Use: Name Field
Style: Normal Bold
Width: 25% page
Align:Left
Set as: $$StringPart:#SVRPartyNameTitle:7:3

[Field: SVR AmountTitle]

Use: Amount Field
Style:Normal Bold
Width: 10% page
Align: Right
Set as:$Amount
format :"No Zero,DrCr,Symbol,"


/*======-Collection Data=====*/

[Collection: for allsalesvoucher]

Option : Coll AllSalesVch: not ##hksort
Option:sort Coll AllSalesVch: ##hksort

[!Collection: Coll AllSalesVch]

Type : Vouchers: VoucherType
Child of : $$VchTypeSales
Compute : partyledgername : $partyledgername
Belongs To: Yes
Fetchartyledgername, amount, vouchernumber, ledger,*.*

[!Collection:sort Coll AllSalesVch]
Use:Coll AllSalesVch
Sort@default:NewSetDataToSort;$partyledgername

[Collection: AllSalesVchColl]
Type : Vouchers: Ledger
Child of : #SVRPartyNameTitle ;$$VchTypeSales
Compute : partyledgername : $partyledgername
Belongs To: Yes
Fetchartyledgername, amount, vouchernumber, ledger,*.*
Filter : VchTypeFilter

[Collection: LedgerwiseTotals]
Source Collection : AllSalesVchColl
By : Name : $PartyLedgerName
Compute : PartyLedgerName : $PartyLedgerName
Aggr Compute: TotalSale : Sum : $Amount
Search Key : $PartyLedgerName

[System : Formulae]
VchTypeFilter : $VoucherTypeName = $$VchTypesales

[Variable:hksort]

Type : Logical
Volatile : No

[Button:sortreport]
Title:If ##hksort Then $$LocaleString:"De-Sort Report" Else $$LocaleString:"SORT Report"
Key: ctrl+x
Action : Set : hksort : NOT ##hksort

[System : Formulae]
NewSetDataToSort : #SVRPartyNameToSort2

 

When value is coming in the new column by party name,
then sort by party name only.
This will also sort according to the new column.

Party name is sorted by $partyledgername.

Till now I do not know how to sort without method name.

If any other member knows please let us know.

 

How to export this report to each party fresh page after party wise sorting?

Press
Alt + E then
Current then configuration

There is no option for "each a/c for fresh page"

How will it come ?

 

Dear sir


I want each party for new page
for print or export in pdf
this report after partywise sort.

 

There are no option in print configuration

 

But in tally
Outstanding - bills receivable - f8
Then export or print
There is option for each a/c new page