Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: How to add/delete/update a column in PRD dynamically

  1. #1

    Post How to add/delete/update a column in PRD dynamically

    How to add/delete/update a column in pentaho report designer PRD dynamically

    Depending on my report query the report format(number of columns to display) should change in a prpt.
    Suggestions please

  2. #2
    Join Date
    May 2016
    Posts
    255

    Default

    Look for it in case is possible, I think I saw it was possible to show sections of the report conditionally, so you could show them different sessions depending on a parameter selected when you execute the report.
    Regards
    OS: Ubuntu 16.04 64 bits
    Java: Openjdk 1.8.0_131
    Pentaho 6.1 CE

  3. #3

    Default

    Quote Originally Posted by Ana GH View Post
    Look for it in case is possible, I think I saw it was possible to show sections of the report conditionally, so you could show them different sessions depending on a parameter selected when you execute the report.
    Regards
    Thanks for the suggestion.
    As I need to schedule the report, I cannot provide a user intervention to select the parameters.
    Any other way through which we can handle such case?

  4. #4
    Join Date
    Nov 2009
    Posts
    667

    Default

    You can look at a cross-tab report

  5. #5
    Join Date
    Sep 2014
    Posts
    7

    Default

    Quote Originally Posted by Ana GH View Post
    Look for it in case is possible, I think I saw it was possible to show sections of the report conditionally, so you could show them different sessions depending on a parameter selected when you execute the report.
    Regards
    Well actually you don't neet a parameter to define it, you can use the columns of the result TableModel as inputs to define conditions based on formulas.

    Wich datasource are you using, because the metada of the query must be retrieved before displaying available columns.

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