formula - SINGLEVALUEQUERY and MULTIVALUEQUERY with Pentaho Report Designer -

i have multiple data sets drive pentaho report. data derived handful of stored procedures. need access multiple data sources within report without using sub reports , believe best solution create open formulas. singlevaluequery believe return first column or row. need return multiple columns.

as example here stored procedure named header in pentaho (call stored_procedure_test (2014, header)), returns 3 values - header_1, header_2, header_3. i'm uncertain of correct syntax return 3 values open formula. below tried unsuccessful.

=multivaluequery("header";?;?) 

the second parameter denotes column contains result.

if dont give column name here, reporting engine take first column of result. in case of multivaluequery function, various values of result set aggregated array of values suitable passed multi-select parameter or used in in clause in sql data-factory.

for more details see https://www.on-reporting.com/blog/using-queries-in-formulas-in-pentaho/