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

Thread: Better example reports for the Report Designer?

  1. #1
    Join Date
    Jan 2007
    Posts
    980

    Default Better example reports for the Report Designer?

    I looked through several of the samples in the report designer's samples directory and found them a bit lacking. Several of them didn't run without changing the definition of datasources and they don't really demonstrate any features.

    I went out to the SF site and found the "demo" zip for the classic engine. It has a handful of .report files in it, but opening any of them in the report designer simply yields a blank structure.

    The pages on wiki.pentaho.org under the Reporting category (http://wiki.pentaho.org/display/PRPT/Home) are mostly empty, many of them just have the string "xml file for page content." as the content of the page.

    Is there some other site or repository of documentation and examples for the reporting system included in Pentaho BI 1.6.0 GA?

  2. #2
    Join Date
    Dec 2007
    Posts
    3

    Default

    I agree, I can't find any examples that show how to pass parameters to a report

  3. #3
    Join Date
    Jan 2007
    Posts
    980

    Default

    I found some more useful examples in the pentaho BI server PCI sample solution. You can import those .xml files using the import option in the designer.

  4. #4

    Default Samples Pentaho

    Hi

    can u send me the lik for the Pentaho BI PCI.
    I have found this link but which one to be installed.

    http://sourceforge.net/project/showf...ease_id=545538

    ilikepentaho.

  5. #5
    Join Date
    Jan 2007
    Posts
    980

    Default

    The 1.6.0.GA opensource installer for your platform.

  6. #6

    Default Samples Pentaho Not Working

    Hi

    thnaks for the reply
    I downlaoded this before so i just wanted to confirm. In this you have the directory bi-server\pentaho-solutions\samples\ correct which have the samples.I tried to use the "getting started" folder. I get the error when i import the index.xml file. the file is not in the correct format.Is it working for you. which samples are working for u.

    Thanks
    ilikepentaho

  7. #7
    Join Date
    Jan 2007
    Posts
    980

    Default

    I used the following command to find a list of the JFreeReport report definition files that you can import into the Report Designer:

    $ find -name "*.xml" -and -not -name index.xml -print0 | xargs --null grep -l DOCTYPE.*JFreeReport
    ./bursting/JFreeQuadrantForRegion.xml
    ./dashboard/jsp/embedded_report.xml
    ./dashboard/php/embedded_report.xml
    ./google/customer_details_report.xml
    ./portal/JFreeQuadrantForRegion.xml
    ./printing/JFreeQuadForRegion.xml
    ./reporting/JFreeMondrianQuadrant.xml
    ./reporting/JFreeQuadForRegion.xml
    ./reporting/JFreeQuadForRegionWithChart.xml
    ./reporting/JFree_ChartComponent.xml
    ./reporting/JFree_SQLQuery_ComboChart.xml
    ./reporting/report-charts/bubble-charting.xml
    ./reporting/report-charts/group-level-time-series-charting.xml
    ./reporting/report-charts/time-series-report.xml
    ./reporting/report-charts/xy-charting.xml
    ./reporting/subreport-example.xml
    ./reporting/subreport-include.xml
    ./reporting/subreport-parent.xml
    ./reporting/subreport-second-include.xml
    ./secure/JFreeQuadForRegion.xml
    ./services/embedded_report.xml
    ./steel-wheels/dashboards/jsp/embedded_report.xml
    ./steel-wheels/reports/dynamically_show_columns.xml
    ./steel-wheels/reports/Income Statement.xml
    ./steel-wheels/reports/order_detail.xml
    ./steel-wheels/reports/Sales_by_Customer.xml
    ./steel-wheels/reports/Sales_by_Employee.xml
    ./steel-wheels/reports/Sales_by_Product.xml
    ./steel-wheels/reports/Sales_by_Productline.xml
    ./steel-wheels/reports/Sales_by_Supplier.xml
    ./steel-wheels/reports/Sales_by_Territory.xml

  8. #8
    Join Date
    Nov 2007
    Posts
    5

    Default Report Designer 1.6.0

    @DEinspanjer

    I attempted to import (using the import feature)

    /reporting/report-charts/bubble-charting.xml
    ./reporting/report-charts/group-level-time-series-charting.xml
    ./reporting/report-charts/time-series-report.xml
    ./reporting/report-charts/xy-charting.xml

    and every one of them return errors. The error returned for the time-series-report.xml is as follows.

    java.lang.RuntimeException: Could not create expression instance for class org.pentaho.plugin.jfreereport.reportcharts.TimeSeriesCollectorFunction
    at org.pentaho.reportdesigner.crm.report.model.functions.ExpressionRegistry.createWrapperInstance(ExpressionRegistry.java:390)
    at org.pentaho.reportdesigner.crm.report.reportimporter.JFreeReportImporter.importFunctions(JFreeReportImporter.java:156)
    at org.pentaho.reportdesigner.crm.report.reportimporter.JFreeReportImporter.<init>(JFreeReportImporter.java:146)
    at org.pentaho.reportdesigner.crm.report.commands.ImportReportDefinitionAsXMLCommand$2.run(ImportReportDefinitionAsXMLCommand.java:240)


    I have not been able to find any "real" documentation on how to actually use the report designer to create a simple chart based on a JNDI connection.

    I was able to set up my dataset but then what? When I assign returned columns to the value columns and series names I get back no data error and I KNOW that the query returns data.

    Any assistance or documentation would be appreciated.

    Regards,

    Gary

Posting Permissions

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