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
dBforums
>
Help with designing a nested report.
07-29-09, 00:14
Linear Mode
