'Express Reports - plsql

I have to design a report with one main report and 6 subreports. I have queries for all seven. I use a tool called Express Report for design purposes. Now I need to get all the reports in a loop.the subreports(6) should get a name from row1 of main report and return values and go to the next row in main report. I'm not able get connection using select query.

Example

Name    count1 count2 count 3    count 4 .... count6
ABC      5      2
DEF      2      3
GHI      4      5

now my report should run the main report row1 ---- should run for subreport ( count1 to count6) row2(of mainreport).... should run for all 6 subreports) end if there is no values.

How can i acheive this with select statement

sqlreport


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions