Add additional column in sales columnar report

Hello everyone,
I want to add 2 columns in my sales columnar report.
1 of party address and other for item group.

Can anyone help me in finding the part/line to be modified?
Or u can also provide the way of finding the part/line
(hovering courser over title is showing the field, not the line in which title and these details to be taken)




I want these 2 columns.

My current code:

[#Line : ]
Add : Field: before: DSP VchType : PartyAddTitle, ItemGrpTitle

[Field: PartyAddTitle]
Use:Name Field
Set as: "Party Location"
Skip: Yes
Width:10
Align: Center

[Field: ItemGrpTitle]
Use:Name Field
Set as: "Item Group"
Skip: Yes
Width:10
Align: Center


[#Line : ]
Add : Field: before: DSP VchType : PartyAdd, ItemGrp

[Field: PartyAdd]
Use: Name Field
Set as:$Address
Width:10
Align: Center
Set Always: Yes
Skip: Yes

[Field: ItemGrp]
Use:namefield
Set as:$parent
Width:10
Align: Center
Set Always: Yes
Skip: Yes

;[Collection: partyadd]
;Type: ledger

;[Collection:itemgrp]
;Type:stockitem

 

[#Line : DSP ColVchTitle] === For Title...


[#Line : DSP ColVchDetail] === For Detail...

 

Sir, how to word work backwords

like is there any way to get line from field, part form line etc.

 

Thank you so much sir.

Sir, I also want the stock item wise group in the same report, can u guide me in the same?

 

Yes
As you can go forward by pressing Ctrl + Left Click og mouse you can go backward by selecting field name and press ctrl + /

Try and inform...

 

Sir with your help by providing me the line and some of my hit and try process i m finally able to get my required information.

working code :

[#Line : DSP ColVchTitle]
Add : Field: Before: DBC VchType : ItemGrp
Local : Field : ItemGrp : Set as : $$LocaleString:"ItemGrp"

[#Line : DSP ColVchDetail]
Add : Field: Before : DBC VchType : ItemGrp

[Field: ItemGrp]
Use : NAME FIELD
Style : Normal Bold
Width : 10
Scroll : Yes
Set as : $Parent:StockItem:#DBCParty
Border : Thin Left

 

Wow sir,
By selecting field name and pressing ctrl+/ over it, I get all the references where that field is available

 

Wow sir ,
This link will surely help new developers like me in increasing our productivity.

Thank you so much for providing this