which reporting tool(s) do you use?

[KennethB.]

Hello all,

 

Which reporting tools do you use to generate reports from Prestashop?
What I'm after is a simple but powerfull ( sounds likes a contradiction right ;-) ) reporting tool where I can generate reports (CSV/Excel/PDF) from the along the lines of:

- Give me an overview of sales during quarter X, split per country with the total excl. VAT, the VAT amount per VAT% etc.
Ideally with some totals at the end and yes I have different VAT rates across the product range I sell and different rates for the different countries I sell to since July 1st

- Or generate a list of active products and their end user price including VAT for delivery to country X (and Y, and Z, etc). You can call it a sort of printed catalog where I could then prepend & append general information like a logo, sales conditions etc
 

Note these are just 2 examples to come to mind, but reporting requirements will of course change over time.
I'm not after a complex BI / dashboard solution, just a simple: I want a static report X, this is what I want it to look like/be able to report on and run whenever I need it.
 

I'm sure I'm not alone with this question, do you have any recommendations or do you all just quickly type in a SQL statement in phpadmin joining some tables and be done with it?

 

Kenneth.

[El Patron]

just import into excel and create spreadsheets.