I have two tables on a report. Across the two tables, I need 8 total columns. The tables have the same data; only the columns shown are different. I need the first table drawn first, and then the next table after that on a new page.
Here's the report structure I would like...
Page 1:
Properties Table
Id | Name | etc...
--------------------
1 | Bob | ...
2 | Matt | ...
3 | John | ...
...
After Properties table, on a new page:
Relationships Table
Id | Relationships | etc...
-----------------------------
1 | Matt | ...
2 | Bob | ...
3 | (NULL) | ...
...
Assuming the data source is the same for both tables (it returns all 8 columns I need), how can I achieve this on the report?
I believe the idea is to use subreports, but I can't find a mechanism to pass in the data from the main report.