on 05-19-2009 8:54 PM
Hello
I noticed strange way of working of the condition in my query. I built the report which contains two characteristics in lines (shop, article) and three columns (value 1, value 2, difference). I built the condition like "difference <> 0" do present only the combinations to be explained. The matter is that it works perfectly, but not in case, when the summary of differences is 0. For example, when I have two lines with differences, one is "2" and second is "-2", the report presents no lines. For another selection, I can have for example three differences, like "1", "2", "-4" - in this case report will give me those three lines as a result.
Any idea?
Arelis
Hi Arelis,
Please check in your query designer if "supress Zero" is active for Rows and column. If yes select "Do Not Supress" You will find this option in Query Properties -> Rows/Column.
Regards,
kams
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.