Suppress 0 rows in Stat report

Moderator: crythias

Locked
troffasky
Znuny newbie
Posts: 53
Joined: 04 Apr 2011, 15:38
Znuny Version: 3.2.8
Real Name: Alex Dekker

Suppress 0 rows in Stat report

Post by troffasky »

I have a report in Statistics that sums TicketAccountedTime per customer for all tickets of Type "Timed Support" over the past 3 months. We set a ticket to type "Timed Support" when a customer needs some support not covered by their contract. Then as part of the billing process, an accounts administrator pulls off this report to generate a bill for the customers who have used timed support.

Now the problem is that the accounts admin doesn't know in advance which customers will have used Timed Support, so CustomerID is All. This generates a 5-page report consisting mostly of 0s because the majority of customers don't use any timed support.

That's the scenario, so my question is, can I suppress empty rows from appearing in the report? I am aware that I can filter it in Excel afterwards by using CSV, but I'm trying to keep this as simple and PEBKAC-resistant as possible.
OTRS 3.2.8 on Ubuntu 12.04.2 LTS
Locked