Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Reporting 5.0.1 dynamic column in the Custom Query

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Oct 2010

    Post Reporting 5.0.1 dynamic column in the Custom Query

    Hi there

    I am beginner of pentaho reporting, i use pentaho reporting version 5.0.1,
    I am going to design a report, the columns in the query is dynamically generated using parameters. What I do is:

    1. I add a JDBC custom query
    2. at root of master report, selected query -> name, then click ... to open custom query window
    3. input query like:
    SELECT ${column}
    where CITY=${city}

    query running is ok, no error, but empty result.

    Can anybody help me figur it out?

    The sample is attached.
    Attached Files Attached Files

  2. #2
    Join Date
    Oct 2010


    Thanks for all who viewed my message. I have found the result.

  3. #3
    Join Date
    Nov 2013



    I'm dealing with the same problem as yours, can you tell me what did you do to make it work ?

  4. #4
    Join Date
    Mar 2014


    Hi qding2008,

    I installed pentaho 5.0 ee version. And the report desginer version is 3.7 ,but I cannot find the JDBC(custom) in Datasets. Name:  Untitled.png
Views: 96
Size:  7.7 KB

    Have it been moved to other place or do i need to configure something.

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 - 2019 Hitachi Vantara Corporation. All Rights Reserved.