Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: Taqua; Keyword(s):

Page 1 of 100 1 2 3 4

Search Forums: Search took 0.08 seconds.

  1. Use a "resource-message" and/or "resource-label"...

    Use a "resource-message" and/or "resource-label" field for all text outputs. These elements look up the text to print in a resource-bundle (which can be embedded in the prpt itself). The bundle is a...
  2. Blazing fast data exports with Pentaho Reporting 5.1

    Ever felt that getting the Pentaho BI-server to spit out CSV or Excel files should be faster? As unbelievable as it sounds, with case PRD-4921 closed, we have up to 5 (in words: five!) times faster...
  3. Understanding and tuning the Java garbage collector

    While working on one of my many side-projects, I stumbled across a very complete and understandable explanation of the various garbage collector algorithms used inside the JDK and their performance...
  4. Replies
    0
    Views
    1,236

    Pentaho Reporting now with Arabic text support

    In the upcoming version 5.1, Pentaho Reporting will now ship with (for this version) experimental support for printing bidirectional text. Bi-Directional text processing enables us to print both...
  5. Beware of file encodings – or the curious case of the broken JDBC passwords

    When we work with text on a computer, we usually seem to take it for granted that whatever we write is stored by the system exactly as we write it. If you are old enough to remember DOS and...
  6. Better Builds (1/3): Speed up the Pentaho Reporting Build

    When developing bug-fixes or new features for software I write (in the context of this blog: Pentaho Reporting), I tend to follow a test-supported development model. Its not the pure “write tests...
  7. Better Builds (2/3): Set up a private CI server to automatically test your work.

    When you finished writing a feature or bug-fix, the big moment of truth arrives: Did I break something?
    Of course, the obvious errors should be validated in the local unit-tests. And all programmers...
  8. Bonus Build – Setting up Jenkins to build and validate pull requests

    In my last post about creating a local build environment, I showed how you can set up a local CI server to validate your local commits.
    When working with Open-Source on GitHub, contributions usually...
  9. Translating Pentaho Reporting in 5 not so easy steps

    I recently was asked on Twitter how Pentaho Reporting can be translated. Translating our software is sadly not as easy as I’d wish it to be. Prepare for a larger project.
    On the positive side of it:...
  10. Use code to replace a datasource in a report

    I’m not exactly a social media user, so I am rather surprised that every now and then I get a question via these channels.

    @PentahoReport could you explain to me, how to use the pentaho sdk with...
  11. Replies
    0
    Views
    4,960

    Your’re hot, Thermometer chart!

    https://www.on-reporting.com/wp-content/uploads/2015/01/PRD-5337-Charts.jpgA couple of days ago, prijip contributed a thermometer chart to Pentaho Reporting. Thank you, it’s good to see that our...
  12. Replies
    1
    Views
    851

    PRD does not have internal styles sheets, we are...

    PRD does not have internal styles sheets, we are primitive compared to browsers. For any particular Element instance, you can use Element#getDefaultStyleSheet() to get the built-in defaults.

    That...
  13. The data-source does not give an indication of...

    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...
  14. Expose your visualisation as raster image or SVG...

    Expose your visualisation as raster image or SVG that is reachable via a HTTP GET call and you can do that easily for all output formats. If you have a choice - supply SVG as this allow beautiful...
  15. Replies
    1
    Views
    825

    No. IText moved license from LGPL to AGPL and...

    No. IText moved license from LGPL to AGPL and moving the whole product to that evil license would upset a lot of people. I think most people would not like to forcefully opensource any of their...
  16. Replies
    7
    Views
    1,121

    Your data source does not define any query. Yep,...

    Your data source does not define any query. Yep, that means you dont get data. Pentaho reporting encourages named queries - your datasource contains the SQL stored with a given and hopefully...
  17. No, parameters are evaluated in order and...

    No, parameters are evaluated in order and evaluated completely when it is their turn. Untrusted values from parameters that have not been validated are not available for use (or someone may do evil...
  18. Replies
    3
    Views
    1,319

    This error is down to an error in the JDK: "...

    This error is down to an error in the JDK: " DnD.Cursor.CopyDrop : cannot load system cursor: CopyDrop.32x32"

    You can try to use OpenJDK 1.8, and if that does not work, you have to use the Oracle...
  19. If your report-designer is newer than the...

    If your report-designer is newer than the platform you are running on, then be prepared for errors.

    Ever tried to run modern software on a old and dusty C-64? Were you surprised it did not work?...
  20. Replies
    2
    Views
    1,024

    If you have a valid license for it, then Arial...

    If you have a valid license for it, then Arial Unicode MS is your best bet. Note that that font is not the same as the plain Arial font.
  21. Increase the socket timeout. Look at the...

    Increase the socket timeout. Look at the postgresql documentation for details on what properties to set:

    https://jdbc.postgresql.org/documentation/93/connect.html
  22. Replies
    2
    Views
    1,965

    First, use JNDI connections instead of connection...

    First, use JNDI connections instead of connection strings. Seriously, you'll never want to use raw connection strings anywhere except when setting up JNDI connections in the data-source manager.
    ...
  23. Replies
    1
    Views
    1,329

    The PDF looks sensible and fine (except for the...

    The PDF looks sensible and fine (except for the logo, which seems to be a low-resolution raster image). Try replacing it with a higher resolution image or a SVG image - vector images are perfect for...
  24. Have a look at the Demo-module on GitHub or my...

    Have a look at the Demo-module on GitHub or my reporting-SDK. Both contain demos on how to display a report in a Swing application.
    ...
  25. Replies
    2
    Views
    901

    You say you "hit" the URL. I assume that means...

    You say you "hit" the URL. I assume that means you:

    (1) make a network connection to the URL.
    (2) Download the JSON payload
    (3) Parse it into a structured tabular format
    (4) Run the report over...
  26. Replies
    1
    Views
    834

    You cant. Functions/expressions only get...

    You cant. Functions/expressions only get evaluated when the report runs, which by definition is after your prompts/parameter have been validated.

    You can run custom scripts via a trick though:...
  27. Woha, thats in the page-setup code and an NPE...

    Woha, thats in the page-setup code and an NPE makes no sense there.

    You can remove the entry from the menus via the global configuration. This then reenables the classic printing mode of JDK1.2...
  28. Replies
    6
    Views
    1,970

    On the dependent parameter use "reset to default...

    On the dependent parameter use "reset to default value on invalid selection" and possibly "use first value if default value formula results in NA" to solve this.
  29. Replies
    2
    Views
    1,507

    Yeah, MDX combines data in the column names and...

    Yeah, MDX combines data in the column names and PRD expects column names to be static. That is a recipe for "fun".

    Simple solution: Edit->Preferences then enable "Display the index columns .." in...
  30. Using Acrobat Reader by any chance? Google for...

    Using Acrobat Reader by any chance? Google for "Acrobat Internet Explorer blank page" and you get a hell of a lot of results. Try a different browser first, to see whether it is something IE specific...
  31. You are mixing concepts, and that is tripping you...

    You are mixing concepts, and that is tripping you up. Lets talk some code:



    String envNameOnServer = "session\\:FACILITY_ASSOCIATION";


    First, lets declare where the data comes from,...
  32. Use a java.io.File instead of an URL object. It...

    Use a java.io.File instead of an URL object. It is as simple as that.
  33. Replies
    3
    Views
    770

    Yes, if that "call xxxx" is in a SQL datasource,...

    Yes, if that "call xxxx" is in a SQL datasource, then you are dealing with a stored procedure. Without access to the database (or at least the permission to run that procedure) you won't have much...
  34. Replies
    2
    Views
    1,271

    Sound like: If all you have is a hammer, ... :) ...

    Sound like: If all you have is a hammer, ... :)

    There is no reason to use the KTR as datasource when - as you said - you are populating a database with that data already. KTRs as data-source are...
  35. Each field is exposed by both its name, and then...

    Each field is exposed by both its name, and then again as "::column-by-index:n". Go to the preferences dialog and you can toggle the setting that exposes those fields in the UI of the report-designer.
  36. Master-report has an attribute in the "query"...

    Master-report has an attribute in the "query" section named "auto-sort". Set it to false to keep your existing order.

    Note that if you do grouping, all comparisons will be equality comparisons, so...
  37. Replies
    3
    Views
    756

    There is a known bug in the report-designer....

    There is a known bug in the report-designer. Create the data-source for the parameter outside of the parameter dialog and then reference it inside the parameter and it should work fine.
  38. Replies
    4
    Views
    1,212

    The report-environment takes it locale from the...

    The report-environment takes it locale from the system locale. You can also set that globally via "Locale.setDefault(..)".

    If you are on the BI-server, the locale is taken from the Accept-header...
  39. This is built in into how Kettle works. Kettle...

    This is built in into how Kettle works. Kettle always starts all steps of a transformation in parallel. If the steps are independent, you can simply move them into their own transformations.
    ...
  40. Replies
    2
    Views
    714

    The simplest example would be this one here:...

    The simplest example would be this one here:
    https://github.com/tmorgner/pentaho-reporting-oem-sdk/blob/master/sample-generate-report-files/src/sdk/generate/patch/PatchAReportSample.java

    This...
  41. Clean up your disk! (@see...

    Clean up your disk! (@see http://stackoverflow.com/questions/7415710/mysql-writing-file-error-errcode-28 )
  42. You cannot do that. What you want to do requires...

    You cannot do that. What you want to do requires time-travel. PRD 6.0 has been released *after* BI-Server 5.4 (as the version numbers suggest). To make BI-Server 5.4 use features developed in a...
  43. The JDK and PRD (when doing PDF) works directly...

    The JDK and PRD (when doing PDF) works directly with the TTF font files. So this font substitution trick wont work. You will need the proper font files instead, or you'd have to edit the Google ones...
  44. Thread: Reports on Tabs

    by Taqua
    Replies
    4
    Views
    662

    Use pagebreaks to create a new sheet. The engine...

    Use pagebreaks to create a new sheet. The engine will interpret page breaks as request to start the sheet. use the "sheet-name" function to set a name (ordinary excel limits like no more than 32...
  45. In the structure tree, right click and use "Bring...

    In the structure tree, right click and use "Bring to front" and "move back" to reorder them.
  46. Replies
    4
    Views
    1,010

    First: Be aware that different parts of the...

    First: Be aware that different parts of the Pentaho projects have different licenses. Kettle is the most liberal, using the Apache License, Reporting uses LGPL, and Mondrian uses the Eclipse Public...
  47. Replies
    2
    Views
    553

    Slight correction: The post-processing should...

    Slight correction:

    The post-processing should return the parameter value if it passes the check, or should fail with ERROR or NA() otherwise. Think of the post-processign as a filter that clears...
  48. Replies
    8
    Views
    1,627

    If you cannot see these characters in the normal...

    If you cannot see these characters in the normal preview, then your database returns garbage. Java, and thus PRD and the Oracle JDBC driver are all using UTF-16 as internal string representation. So...
  49. Replies
    1
    Views
    550

    Your formula is fine, but string comparisons are...

    Your formula is fine, but string comparisons are both case sensitive and sensitive to leading and trailing whitespace. Are you sure the content of "wb_status" is actually "In process-design"?
    ...
  50. Replies
    3
    Views
    1,054

    A report that runs on a web-server, one that...

    A report that runs on a web-server, one that potentially is thousands of miles away from your computer that runs the browser, cannot directly write to your file system. The basic feature you request...
Results 1 to 50 of 5000
Page 1 of 100 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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