Need another Help

Dear Experts
I need your another help, in my report at closing balance of creditors it is not showing whether it is Dr or Cr, it is just showing balance amount only please help on this ................for your kind reference the picture & the code is

[Field : C Closing Balance]
Use : Short Number Field
Set as : $ClosingBalance
Style : Normal
Border : Thin Left
Width : 12
Align : Right

 

Use
Format : "CrDr"

 

Manoj Sir How to use it, this code is not showing whether it is Dr or Cr

[Field : C Closing Balance]
Use : Short Number Field
Set as : $ClosingBalance
Format : "CrDr"
Style : Normal
Border : Thin Left
Width : 12
Align : Right

 

you can use this also
Set As : If $$IsDr:$ClosingBalance then $$String:$ClosingBalance + " Dr" else $$String:$ClosingBalance + " Cr"

 

Waoooooooo
Thank you Very much sir

 

THANK U GREAT SIR

 

Set As : If $$IsDr:$ClosingBalance then $$String:$ClosingBalance + " Dr" else $$String:$ClosingBalance + " Cr"

 

You can also use like following.

[Field : C Closing Balance]
Use : Short Number Field
Set as : $ClosingBalance
Format : "DrCr"
Style : Normal
Border : Thin Left
Width : 12
Align : Right

 

how to get closing balance as on voucher entry date, i want display in ledger collection list in voucher entry screen

 

Try this hope this will work for you as its work for me ..........
[Field : C Closing Balance]
Use : Amount Field
Format : "All Symbols,DRCR"
Set as : $ClosingBalance
Border : Thin Left
Width : 12
Align : Right

 

Manoj Sir How to use it, this code is not showing