postgresql - How to create dynamic sql query in pentaho report designer PRD 5.3? -
i using petaho report desiner
my main query
select create_date , sum(product_uos_qty) sale_order_line group create_date
it running properly
and sub query
select column_name information_schema.columns table_schema='public' , table_name='sale_order_line' , (column_name = 'product_uos_qty' or column_name ='price_unit')
output of query
product_uos_qty price_unit
i create parameter select
and convert main query this
select create_date , sum(${select}) sale_order_line group create_date
but not running gives following error
error: query 'main' did not execute successfully. reason given was: 'org.pentaho.reporting.engine.classic.core.reportdatafactoryexception: failed @ query: select create_date , sum(${select}) sale_order_line group create_date'
tell me main problem , how can solve it
Comments
Post a Comment