Need Help on this complex report [closed]

This question is unlikely to help any future visitors; it is only relevant to a s开发者_StackOverflowmall geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center. Closed 11 years ago.

I have to create a report on Microsoft Reports in Visual Studio 2008. I have an Author Table, a books Table and a shops table that has these books.

Now, I need to get all authors from authors table based on its author_ID, I need to display all the books of that author and then all shops of that are selling the books of that author.

So each page will be like this:

    -Author Name

     |---Books of this author [I am using List]

       |----Book 1

       |----Book 2

       |----Book 3

       |----Book 4

     |----Shops Selling these books [Again List in a Sub Report, Author_ID as Parameter]

       |----Shop1

       |----Shop2

       |----Shop3

       |----Shop4
-------------------------------------

Then Repeat the same layout in the next page for the next author. Its getting complex as I am putting this whole layout in a list and then using list for Books of that author and then a subreport with list to display Shops. Is there any simple way to do it? Any Idea would be a great help.

---

Never mind I solved it using Sub reports.