Reporting 5.0.1 dynamic column in the Custom Query

[qding2008]

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.

[qding2008]

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

[nawaa]

Hi,

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

[juanli2]

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.

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