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.