Skip to Content
Former Member
Mar 15, 2007 at 05:23 AM

How to uncheck the "Suppress Zero colums/rows" option in query properties?


Hi All,

When I execute the query it displays the result hiding one of the colums. I need to go to the column header > right click on it and select All Characteristics > then uncheck the option "Suppress Zero colums/rows" to get the correct result of the query. Can i get this option "unchecked" before the query runs ? Where and what changes need to be made in the query properties before running the query ?

Please let me know how to go about it.