Hi All,

I'm into a situation where I need to run N number of queries through pentaho report designer and have to merge the result set at the end as output.

For instance, I have to run 5 individual queries separately and combine the result set at the end.

Any suggestions will be appreciable.