Reply to comment

Hi,

    Based on your given example, i think you could use subreport with JDBC datasource. Create two subreport let say A and B where A is for main accounts where account type is 'View' and B for normal reports. Create a new main report and in the main report, fetch all the accounts that has the type 'View'. Create a group to group this accounts. In the group properties, set start on a new page property. The details band of the main report should contain the subreport A which is for the account of type "View". Pass the accont number from the main report to the subreport as a parameter.

     In sub report A fetch details of the accounts that comes under the main account that is passed from main reports. The pattern of the sql query should be:

<Query to fetch account details> where parent_id in $P{account from the main report}

       create a group in subreport A which groups the child accounts fetched. The details band of the subreport A should contain the subreport B. Set the property of the group to start on a new page. Pass the account number of the child account fetched in to the subreport B as parameter.

        In subreport B, display the details of the child account  passed from the sub report A. 

        I think this could help you......