How do you suppress zeros in B.O. Deski XI

[system]

Posted in General Discussion by accident. Producing a report that shows revenue and want to suppress those clients that have zero for revenue in order to sort from highest to lowest.

---

Clara (BOB member since 2012-09-18)

[system]

Moderator Note: I deleted your other post in General Discussion.

Welcome to B:bob:B! Where do you want the zeroes to be suppressed? At the report level? Or at the query?

---

Jansi (BOB member since 2008-05-12)

[system]

Either will do. Just need them suppressed in order to do the sort from highest to lowest which keeps putting the zeros at the top of the list. Can you tell me of both options, please?

---

Clara (BOB member since 2012-09-18)

[system]

In your query add one more condition
which says <> 0

In the report, you can add a report filter or a block filter to eliminate 0s.
The way to apply a filter to a block is described here.

120×120 10.4 KB

Hi all, I’m creating a report with two sheets. They both show the same data but once in table form and once as a chart. The problem now is that I have too much data… There should be a constraint on some values. Like the record should only be shown when there are more than 5 . BUT and this is the problem: Those values are already self made variables and I don’t know how to filter on these… Is it even possible ? Thanks in advance, Tom [image] TCL (BOB member since 2008-09-01)

---

Jansi (BOB member since 2008-05-12)

[system]

I don’t understand. I know how to do filters but how do I do blocks to suppress the zeros? Looked at the link you sent but didn’t understand.
Example: Revenue is:

1,000
200
3,999
0
30
500
0

When I sort the zeros end up on top in lieu of 3,999

---

Clara (BOB member since 2012-09-18)