Hitachi Vantara Pentaho Community Forums
Results 1 to 10 of 10

Thread: A jasper report ouput plugin , may be useful to jasper developers.

  1. #1

    Lightbulb A jasper report ouput plugin , may be useful to jasper developers.

    This plugin is what I developed one year ago for a jasper report project.
    now the projcet is finished, so I release this plugin, maybe it 's useful for other jasper&kettle developers.

    This plugin can pick up rows from the previous step and bind data to the Jasper Report Filejrxml file, then generate a HTML/PDF/Excel report by the Jasper Report Engine.


    you can download source here! under GNU LGPL
    svn://xgndata.com/kettle/plugins/jasperreport

    (see attachment for user guide)
    Attached Images Attached Images
    Jason chu
    Beijing Aofei BI Consulting.
    Web: http://www.pentahochina.com
    Email: jianjunchu@gmail.com

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Hi Jason,

    Some folks have requested for the new "Pentaho Reporting Output" plugin to be available in PDI 4.2.
    However, I see no reason for the "JasperReport Output" to be excluded.
    Would that be something you are interested in too?

    Regards,
    Matt

  3. #3

    Default

    Hello!

    Most of the reporting in my company is already done with PDI. It beats everything else in flexibility, e. g. generating HTML mails or Excel files. It's also easier to use and schedule than Xactions in the BI server.

    When a "styled" report is necessary, it must be done with kludges like executing a script that uses a command line JasperReports runner.

    I'm currently experimenting with the Pentaho Reporting plugin and would be very glad if a JasperReports plugin was included, too.

    Reporting functionality included in the Kettle core would make it much more useful.

    Regards,

    Balázs

  4. #4

    Default

    I found some limitations but got it to work with a complex report of my company.

    For dates, use only java.util.Date, not java.sql.Date (which would be the case if you developed the report with a SQL query in iReport).

    Errors are only written to the standard output but not displayed in Spoon so if your report ends up as an empty file, check the terminal window which you used to start Spoon.

  5. #5
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Thanks for coming back to us on these issues balazsb. I'll have to think of a wrapper around this to capture the logging lines to move them over to the PDI logging infrastructure.

  6. #6

    Default Diff for setting REPORT_LOCALE

    Attached is a small diff file to support setting REPORT_LOCALE as a parameter. (It needs to be added in JasperReports as a java.util.Locale object so specifying it as string is not sufficient.)

    With this patch, one can set the parameter REPORT_LOCALE to a string like de_AT and it will be passed in the right way to the JasperReport output object. This allows reports to show the correct number formatting.
    Attached Files Attached Files

  7. #7

    Default

    Any Update regarding the Jasper Plugin?

    Regards,

    Ben

  8. #8

    Default

    Where can I download the Jasper Plugin?

    Any advice?

    Regards,

    Ben

  9. #9
    Join Date
    Nov 2008
    Posts
    143

    Default

    Ben, it's in the very first post of this thread.
    Get the source code from the svn link and compile it.
    I don't think there's a "packed" version available somewhere.

  10. #10

    Default

    Thanks renatopb for the advice,

    I have checked the link, but apparently it is not active. If I could dl it, I would´t know how to compile it. It will be nice to have it packed or on a Kettle Release.
    By the way Matt mentioned something about including it in the 4.2 realease. any news?

    Thanks,

    Ben

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.