Posted on: 7/2/2013 6:02:27 PM | Views : 263

Hi,
I have a report viewer on my page.  I know how to populate gridviews, etc and databind them to my report.
However, I am trying to generate an overall report for data in my database where relationships are one to many.
For instance, I am trying to create a single report that will list each business in Table1.  And for each of those businesses, I need to generate all the data that is located in all my others tables.
So...Page 1 would be business1 and all of its assocaited data.  Page2 would be business2 with all of its associated data, etc. etc.
How do I get it to loop through all of the data and keep it all grouped by business?
Thanks.
...

Go to the complete details ...