parames
21st October 2002, 06:28
Hi list,
my report layout looks like this:
header
before.field - tiitm001.item
detail
after.field - tiitm001.csgs
detail-- Print out the stock balance by item code
output.Expr -- print.rep<>0 (which means in the program script i have do some validation where if the stock balance is 0, then don't print the item) ex : col.inv <> 0 then print
after.field -- print out the sum of the stock balance by statistic group. (ex: total for col.inv)
But, how to control here so that if the sum balance is 0, then don't print out the line....ex: if total con.inv <> 0 then print..
I've tried to put (in maintain layout) -- "col.inv <> 0", but cannot..
Any Ideas?????
FYI: I'm doing stock aging where this report will print out the stock balance based to month...
item code --- first month ---- sec month --- third month ---......
AAAA --- 123.33 --- 333.33 --- 444.44 -- ....
The stock balance is taken from tdilc101 order by dates..So, my values in "detail" are from program.scripts ..
my report layout looks like this:
header
before.field - tiitm001.item
detail
after.field - tiitm001.csgs
detail-- Print out the stock balance by item code
output.Expr -- print.rep<>0 (which means in the program script i have do some validation where if the stock balance is 0, then don't print the item) ex : col.inv <> 0 then print
after.field -- print out the sum of the stock balance by statistic group. (ex: total for col.inv)
But, how to control here so that if the sum balance is 0, then don't print out the line....ex: if total con.inv <> 0 then print..
I've tried to put (in maintain layout) -- "col.inv <> 0", but cannot..
Any Ideas?????
FYI: I'm doing stock aging where this report will print out the stock balance based to month...
item code --- first month ---- sec month --- third month ---......
AAAA --- 123.33 --- 333.33 --- 444.44 -- ....
The stock balance is taken from tdilc101 order by dates..So, my values in "detail" are from program.scripts ..