Ad-hoc report of SpagoBI is powerful yet easy to create. In fact, it is the best ad-hoc reporting tools among free and open source BI solutions to date. Ad-hoc report is report that user can create by themselves without touching any code. The hardest part would be to get the SQL that retrieve data from database. The rest will be drag and drop kind of action to create various kind of reports, e.g., List Report, Crosstab Report, Pie Chart, Bar Chart, etc.