pentaho can connect to multiple data sources. The problem is i struggle to combine that data from multiple data sources to be displayed on one report. it only displays data from one data source.

i used subreport to do that it displays. the next problem is if i want to use the output of one data source in the where clause of the other Sqlcomponent that connect to different data source. then the subreport does not display i.e it does not execute. i used the import parameter it did not display(${importparamater})

Thanks

Aron