Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Hierarchies and Drill Down in Pentaho report designer

  1. #1
    Join Date
    Jul 2012

    Exclamation Hierarchies and Drill Down in Pentaho report designer


    I wanted to create a drill down report . Where when i click on device vendors i get device models of that vendor. I achieved this by creating hyperlink and then linking to another report which contains device models.

    However, this is not exactly we want. can't we drill down on the same report on the same page. like if i show device vendor and txns then if i click on one of the device vendor say LG it should drill down on device models of LG and show their txns. Don't we have concept like Hierarchies in Pentaho?Actually,after working on high level tools, working on pentaho seems very out of track...

    Please reply if anyone has any ideas on this.


  2. #2
    Join Date
    Mar 2003


    Use anchors to build internal link targets in your detailed report. Use the HTML anchor style to construct a unique, but predictable, identifier for your link target. Use a formula on that style for that, something like:

    ="Vendor-" & [VendorID]
    To get a summary of your data, add a subreport to the report-header. Inside the subreport, add the links to your anchors of your main-report.
    Then you can add a link (style "url") to that target. Again, use a formula for it:

    ="#Vendor-" & [VendorID]

    As long as the link and link-target are contained in the same generated document, you will be able to jump to the target of the link. Note that when previewing the document as paginated HTML in the BI-Server you will NOT be able to use these links, as your browser cannot find link targets of pages that have not been generated. Use the non-paginated "streamed-html" output mode for your report instead. All your content will then be contained in a single web-page.

    Linking also works fine for PDF export.

    All other export document types (like Print, Excel or RTF) do not have sufficient capabilities to handle links of that nature. This limitation is not fixable, as it is built in into the specification of the document format we output. It would require the actual developers of these formats (Microsoft for Excel, for instance) to change their formats. I suspect that happens the day the moon explodes.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

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 - 2017 Pentaho Corporation. All Rights Reserved.