Not able to loop a subreport from master report to print the bands in subreport horizontally in Ireports

[dhiraj.kene]

 

I have created a report in which i am having a subreport subreport.The Subreport contains The subreport contains another subreport which subreport which has column and detail band Detail band which i I wanted to print horizontally in excel based Excel based on some looping condition.

masterreport -->SubreportMaster> SubreportMaster -->SubReport1> SubReport1 (Containing detail and column band Detail and Column band) 
Below are the steps:

1) Set the property of SubreportMaster to print horizontally 
2) Set the column number dynamically from the design object as per the requirement. Assume 2 in my case.

When i ran the report the Subreport1 bands are not printed  .If If i change the print order to vertical the bands are getting printed properly.

Please advise if their is any another way to loop a subreport to print the contain horizontally.