Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Show the evolution of reading records in pentaho RD preview

  1. #1
    Join Date
    Sep 2016
    Posts
    16

    Default Show the evolution of reading records in pentaho RD preview

    Hi.
    I'm developing a java application that calls a report made in Pentaho Report Designer. The report in turn takes the data from a Pentaho DI transformation. The data is read from excel sheets and can exceed 200,000 records.
    Once the report preview screen appears, can you get a screen that shows the evolution of the reading of the data?
    Having so much data it is very heavy to wait for the results of the report to appear and if you could put some distraction the user would know that the program is not hung.
    Thanks in advance.

  2. #2
    Join Date
    May 2014
    Posts
    358

    Default

    The latest version of the BI server (7.0) shows a progress bar when generating a report.

  3. #3
    Join Date
    Sep 2016
    Posts
    16

    Default

    Hi luckfy.
    Thanks for your answer.

    I do not use Bi Server. I'm using Netbeans and implement Pentaho RD 6 and 7 in my java standalone application.

    They are independent reports bound from java applications.
    The progress bar that you indicate to me does appear when you launch the report, but it is active when Pentaho RD is receiving the data.
    While the transformation is running from Pentaho DI the report screen does not show any evolution and it seems that the system is hung.
    What I would like to know is if there is an option in Pentaho RD so that when calling the data source it captures the messages
    that Pentaho DI may be generating.

  4. #4
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    The data-source does not give an indication of how long it will take to get the data, and the reporting engine cannot start working until all data is there. The cheap solution is to set the ProgressBar to "indeterminate" state until you receive a progress event that has the total rows set. Sadly the ReportProgressBar, ReportProgressDialog as well as the PreviewDialog/Frame have no getters to let you get to that JProgressBar. (Yeah, I was pretty good writing locked down code. )

    My recommendation is to copy the 3 classes involved and to change them (as edited source-code) in your project. If you are unsure about the LGPL impact simply keep these classes in a separate library (they wont depend on your business logic anyway) and ship the changed sources for these 3 classes long with your product.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  5. #5
    Join Date
    Sep 2016
    Posts
    16

    Default

    Hi, Taqua.
    Thanks for your reply.
    I'll try to prove what you say and I'll tell you something.

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.