Ad-hoc report writer

[John Taylor]

Can someone advise which reporting product is embedded into the PSA? The documentation on it from Pulseway is weak, so we'd like to find other sources of help. Knowing what the product is would help a great deal.

[Chris]

Hi John,

If you will open the Reporting tab -> Ad-hoc reports, then at the top right corner you will see the help icon.

[John Taylor]

HI Chris,

I had found the help section, but one needs a place to turn when that proves to be inadequate.  It appears you are embedding a product called Exago BI. There are some additional resources on their website, although not enough to solve my problem - which is how to sort on a group aggregate. Simple requirement is a report with two columns:

Customer    |    Total Tickets

Getting the basic report was easy enough, but finding a way to sort on the Agg.Count(Ticket.Id) in the group footer is proving difficult. I'm guessing i need to create a sub-report for this. This would be such a simple thing if we could just write our own SQL.