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

[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)