US and Worldwide: +1 (866) 660-7555
Results 1 to 2 of 2

Thread: Blank report output

  1. #1
    Join Date
    Oct 2008
    Posts
    1

    Default Blank report output

    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?
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2003
    Posts
    7,557

    Default

    One of the shortcomings of the current report-designer is that the *.report files are in no format the reporting engine understands.

    You have to export the report into a *.xml file (via "file->publish" in the report designer) to make the report-definition accessible in the engine. Then pointing your code to that file will make it run.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •