Query: In a Report, can we display zero in the Amount Field, if the value is empty? Solution: Currently, Amount Fields allow setting only non-zero values. In order to force zero onto fields bearing empty values, the Type of the Field must be changed to either String or Number optionally (if the value is zero) and Zero can be set in the Field. If the Field Type is set to Number, the Attribute Format must be set to Zero. Example: Following code sets zero in Debit and Credit Fields that are Empty within the default Trial Balance Report: [#Field: DSPClDrAmtA] Option : DSPClDrAmtA Number : $$IsEmptyFldValue [!Field: DSPClDrAmtA Number] Inactive : No Type : Number Format : "Zero" [#Field: DSPClCrAmtA] Option : DSPClDrAmtA Number : $$IsEmptyFldValue
thanks sir i try this logic to qty field but not work how can it display 0 qty when my field is empty ? pl help
[#Menu:gateway of tally] Add:Item:BPR stock : Alter:bprreport [Report:bprreport] Form:bprreport Variable:svtodate MultiObjects:mystkcoll [Form:bprreport] Part:bprheading,bprreport Button:exportbutton [Part:bprheading] Lines:cmpnm,rpthead [Line:cmpnm] Field:medium prompt,name field Local:Field:medium prompt:Info:"BPR Report For " Local:Field:name field:Info:##SVCurrentCompany [Line:rpthead] Field:medium prompt,name field Local:Field:medium prompt:Info:"As on date " Local:Field:name field:Info:##svtodate [Part:bprreport] Line:bprtitle,bprline Repeat:bprline:mystkcoll Scroll:Vertical Common Border:Yes [Line:bprtitle] Use:bprline Local:Field:default:Type:String Local:Field:default:Color:BLUE Local:Field:default:Lines:2 Local:Field:srno:Info:"Sr. No." Local:Field:srno:Full Width:No Local:Field:itemnm:Info:"Item Name" Local:Field:itemgrp:Info:"group Name" Local:Field:erpclosing:Info:"ERP Stock" Local:Field:buffstock:Info:"BUFFER (Final Norm)" Local:Fieldkstock:Info:"Ok Stock (On Hand Stock)" Local:Field:dispqty:Info:"Disp. Clearance to Foundry" Local:Field:extrareq:set as:"Extra Requirment" Local:Field:bprcolor:Info:"BPR Color Code" Local:Field:bprcolorelete:Background Local:Field:extrareqelete:Storage Local:Field:extrareq:Type:String Border: thin top bottom Delete:Remove if [Line:bprline] Field:srno,itemnm,itemgrp,erpclosing,buffstock,okstock,bprcolor,dispqty,extrareq Remove if: $$IsEmpty:$bufferstock:stockitem:$stockitemname Selectable: No [Field:srno] ;Use: short name field Set as:$$Line Skip:Yes Full Width:No [Field:itemnm] Use: name field Set as:$stockitemname Skip:Yes Full Width:Yes [Field:itemgrp] Use: name field Set as:$parent Skip:Yes Full Width:Yes [Field:erpclosing] Use: name field Set as:$closingbalance ;Set as: $$ToValue:##svtodate:$closingbalance Align:Right Skip:Yes Full Width:No [Field:buffstock] Use: qty field Set as:$bufferstock:stockitem:$stockitemname Skip:Yes [Field:bprcolor] Use: short name field Set as:"" Width: 5 Skip:Yes Backgroundmybprcolorcode formulaa: (#okstock * 100) / #buffstock mybprcolorcode:if @formulaa = 0 then "Black" else if @formulaa < 33 then "red" else if @formulaa > 34 and @formulaa < 66 then "yellow" else if @formulaa > 67 and @formulaa < 99 then "green" else "white" Full Width:No [Fieldkstock] Use: qty field Set as:$$FilterQtyTotalendingBatches1:myokstock:$closingbalance Skip:Yes [Field:dispqty] Use:qty field Align:Right Set as: $$AsQtynotzero notzero: if @otherthanrej <= 0 then 0 else $$AsQtyotherthanrej otherthanrej:#buffstock - #okstock + @myextraqt myextraqt : if #extrareq < = 0 then 0 else #extrareq Skip:Yes Full Width:No Set Always:Yes [Field:extrareq] Use:qty field ;Set as:$extraq:stockitem:$stockitemname Set as:if $extraq < = 0 then $$AsQty:0 else $$AsQty:$extraq Storage:extraq Format : "Symbol, Short Form, No Compact" Full Width:No [Collection:mystkcoll] Type:stock item Fetch:stockitemname,closingbalance,name,extraq Sortefault:$parent [System:Formulae] myokstock@a1 and @@a2 and @@a3 a1: $GodownName not contains "MR" a2:$GodownName not contains "CR" a3:$GodownName not contains "UD" [#Form:stockitem] Addart:After:STKI Basic:bprdetails [Part:bprdetails] Line:bprdetails,extraqty [Line:bprdetails] Field:medium prompt,bpr qty field Local:Field:medium prompt:Info:"Buffer Stock" [Field:bpr qty field] Use: qty field Set as:$bufferstock Storage:bufferstock [Line:extraqty] Fields:medium prompt,extraq Local:Field:medium prompt:Info:"Extra Requirment" [Field:extraq] Use:qty field Format : "Symbol, Short Form, No Compact" Storage:extraq [System:UDF] bufferstock:Quantity:3800 extraq:Quantity:3900 [#Part: STQ Batch Details] Lines : STQ BatchIntro, STQ Godown Titles, STQ Godown Details BottomLines : STQ BatchTotals Repeat : STQ Godown Details : Pending Batches Total : STQGodownQty Scroll : Vertical Width : 50% Page Page Break : DSP ContLine, DSP STQBatchOpBreak [Collection: Pending Batches1] Type : Batch ;Child of : ##StockItemName Child Of:#itemnm Compute : GodownName : $GodownName Compute : BatchName : $BatchName Compute : ClosingBalance: $ClosingBalance