I am trying Pentaho Report Designer 2.0.0 in combination with JFreeReports Classic 0.8.9.9 to show reports over the web and so far I have been unable to get any report output.
From the designer I can preview the report correctly, but on the same machine and database when I run the following JSP code on Tomcat I always get a blank page as a result.
JFreeReportBoot.getInstance().start();
JFreeReport report = ReportGenerator.getInstance().parseReport(new File("C:\\Meetings.report"));
HtmlReportUtil.createStreamHTML(report,response.getOutputStream());
I have also tried to assign a DataFactory programmatically by doing:
SQLReportDataFactory dataFactory = new SQLReportDataFactory(provider);
dataFactory.setQuery("default", "SELECT dt_start,tx_meeting FROM k_meetings");
TableModel oTbl = dataFactory.queryData("default", null);
report.setDataFactory(dataFactory);
and it doesn't work neither, the TableModel gets filled with some rows but they are not shown at the report.
CSVReportUtil.createCSV(report, ouputstream, "Cp1252")
also returns me no results
Am I missing something?


Reply With Quote