Suppress Record on 0 value
[72 byte] By [gazala] at [2007-11-20 9:03:25] 
Is it possible not to print a record if one of the field in query is 0 ?
# 1 Re: Suppress Record on 0 value
yes it is posible but record number shoud be there in dataset or table.so redesign your query and add a field named rownumber then use formula and compare rownumber.if it is not 0 then display the record.
remember in prayers.
Online available at habibhussain82@gmail.com
habibhussain at 2007-11-9 14:10:40 >
# 2 Re: Suppress Record on 0 value
can you please extend the code to display or not to display record if value is null or 0 ?if isnull(field) or filed = 0 then
???
gazala at 2007-11-9 14:11:40 >
# 3 Re: Suppress Record on 0 value
In the Section Expert Window, highlight the section you want to suppress conditionally, check Suppress, then click the X+2 button to the right to the Suppress option and print such a formula:isnull({your_table.field}) or {your_table.filed} = 0
SvB_NY at 2007-11-9 14:12:38 >
