Hello guys,

I have two tables
PHP Code:
  Table 1
--------------------------------
ID   ||    Amount ||  Installments
 1             500            4
 2             200            5 

   Table 2
--------------------------------
SNo ||  ID   ||    Company || Share
 1          1             ABC           200
 2          1             EFG           400
 3          2             MNO          500
 4          3             PQR           200 
One row in table 1 has multiple child rows in table 2 wrt ID.

I have included select statement for table 1 in my main report and for table 2 I have used a sub report.

Now there is a need by our management that further records should be shown in the sub report on number on installments in Table 1.

Like for 4 installments , then we should have 4 subreports.

Like for ID 1,

We should have report like

PHP Code:
       Main report :      ID 1          Blah blah
---------------------------------------------

        
Sub report Installment 1           ID1

             Company  ABC           200
             Company  EFG           400
        
----------------------------------------------
                  
      
Sub report Installment 2           ID1

            
             Company  ABC           200
             Company  EFG           400

----------------------------------------------
                  
      
Sub report Installment 3           ID1

            
             Company  ABC           200
             Company  EFG           400

----------------------------------------------
                  
      
Sub report Installment 4           ID1

            
             Company  ABC           200
             Company  EFG           400

----------------------------------------------
                  
              
End of report 

Is there any solution ? by creating a SQL view or something ? Please help guys I might loose the job if this report is not finished