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.09 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. Replies
    1
    Views
    881

    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...
  3. 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...
  4. 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...
  5. Replies
    1
    Views
    871

    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...
  6. Replies
    7
    Views
    1,159

    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...
  7. 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...
  8. Replies
    3
    Views
    1,366

    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...
  9. 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?...
  10. Replies
    2
    Views
    1,065

    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.
  11. 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
  12. Replies
    2
    Views
    2,031

    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.
    ...
  13. Replies
    1
    Views
    1,386

    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...
  14. 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.
    ...
  15. Replies
    2
    Views
    939

    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...
  16. Replies
    1
    Views
    866

    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:...
  17. 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...
  18. Replies
    6
    Views
    2,019

    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.
  19. Replies
    2
    Views
    1,568

    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...
  20. 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...
  21. 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,...
  22. 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.
  23. Replies
    3
    Views
    801

    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...
  24. Replies
    2
    Views
    1,303

    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...
  25. 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.
  26. 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...
  27. Replies
    3
    Views
    778

    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.
  28. Replies
    4
    Views
    1,252

    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...
  29. 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.
    ...
  30. Replies
    2
    Views
    738

    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...
  31. Clean up your disk! (@see...

    Clean up your disk! (@see http://stackoverflow.com/questions/7415710/mysql-writing-file-error-errcode-28 )
  32. 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...
  33. 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...
  34. Thread: Reports on Tabs

    by Taqua
    Replies
    4
    Views
    686

    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...
  35. 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.
  36. Replies
    4
    Views
    1,061

    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...
  37. Replies
    2
    Views
    580

    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...
  38. Replies
    8
    Views
    1,678

    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...
  39. Replies
    1
    Views
    578

    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"?
    ...
  40. Replies
    3
    Views
    1,087

    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...
  41. Replies
    4
    Views
    1,061

    Pentaho Reporting (engine and report-desiger) is...

    Pentaho Reporting (engine and report-desiger) is fully licensed under the LGPL v2.1. Pentaho stopped using the Mozilla license ages ago.

    With LGPL software, you are free to use it as you want, but...
  42. Replies
    3
    Views
    1,011

    Your formula produces the result ...

    Your formula produces the result

    http://jira/browse/PROJECT-123target="_blank"

    which is then encoded and put into the HREF attribute of an "a" tag. We quote attribute values to prevent code...
  43. Replies
    3
    Views
    1,011

    Drilldown wants to work with parameters, not path...

    Drilldown wants to work with parameters, not path elements of URLs.
    Why not the much simpler formula:


    ="http://jira/browse/" & [JIRAID]

    instead?
  44. Replies
    2
    Views
    765

    Yes. That is how database connections are made...

    Yes. That is how database connections are made machine/runtime dependent.
  45. Replies
    4
    Views
    1,952

    The github project comes with a complete IntelliJ...

    The github project comes with a complete IntelliJ setup, so after checking it out, you should be able to run it immediately.

    you will need to download all 3rd party libraries before you can use...
  46. Replies
    2
    Views
    787

    The BI-Server 5.4 already ships with Pentaho...

    The BI-Server 5.4 already ships with Pentaho Reporting 5.4. However, the BI-server is a web-application, accessed through the browser. THe report designer is a desktop application. So you cannot...
  47. Replies
    3
    Views
    1,831

    The first parameter of the SINGLEVALUEQUERY...

    The first parameter of the SINGLEVALUEQUERY function is the name of the query (as defined in one of the data-sources). It is not the name under which that data will be available to the report.

    If...
  48. Replies
    1
    Views
    543

    There was never a 4.0 release. The BI-Server 4.8...

    There was never a 4.0 release. The BI-Server 4.8 ships with the reporting engine 3.9.1, which was released at the same day as the 4.8 server. Starting with BI-Server 5.0, we decided to bring all...
  49. Replies
    3
    Views
    3,042

    If you got redirected, then your...

    If you got redirected, then your username/password was wrong. The Pentaho Server does not respond with a proper error on that event - it simply redirects you to the login page. If you were logged in...
  50. You need a valid JDK (we test with Oracle ones,...

    You need a valid JDK (we test with Oracle ones, OpenJDK should work too, but not any of the other, incomplete JDK-clones, like gcj. They wont work.). If you dont have an X11 server running, you need...
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.