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.
Suppress 0 rows in Stat report
Moderator: crythias
-
- 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
OTRS 3.2.8 on Ubuntu 12.04.2 LTS