...
and then right clicking in the selected cells and selecting Merge Cells from the menu
This way when we add the new data set to the existing table it'll fill up the width of the parent table. You don't have to do it this way, and you may find better methods of laying out your report pages, but this is to demonstrate linking data sets, not how to layout pages.
From here we can just drag and drop the new data set into the area we've just created in the existing table
Info |
---|
Remember to hide the _id column if you don't want it to appear in the final report |
Then if we generate the report we'll have sales information for each property