How to include subreport from SQL query in jasper reports?

[annadater]

I have few(around 30) static block and I have created subreports for it. Now I want to display subreports based on query output from master report.

In the query itself I have kept name of the subreport to load but when I am running the report I can see that the subreport is loaded but it does not display the output.

For example: If there are 3 rows returned on master report it will return report name something like this >>

1 SomeData Report1.jrxml 
2 SomeData Report2.jrxml 
3 SomeData Report3.jrxml 

I am using the third column for loading subreport dynamically.

Attached an image below for the reference