Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Reporting 5.0.1 dynamic column in the Custom Query

  1. #1
    Join Date
    Oct 2010
    Posts
    24

    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}
    FROM OFFICES
    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
    Posts
    24

    Default

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

  3. #3
    Join Date
    Nov 2013
    Posts
    19

    Default

    Hi,

    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
    Posts
    3

    Default

    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: 89
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.