Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Reporting 5.0.1 dynamic column in the Custom Query

Threaded View

Previous Post Previous Post   Next Post Next Post
  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

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.