Is it possible for me to include a sub report in a tablix row that is grouped by an ID?

Question

Is it possible for me to include a sub report in a tablix row that is grouped by an ID and pass that ID into the sub-report to be ran? Basically, the sub-report would return data from a second dataset based off of the ID that is being used in the grouping of the main tablix?

My main tablix has 4 rows that are grouped together by an ID where i create a few graphs from a main dataset. My second dataset returns simulations that can contain hundreds of rows per ID, which is why I don't want to do this in a join statement because it is extremely ineffecient. I want to add a tablix to row 5 within my main tablix and display the results from dataset2, but only have it run within the current group of Tablix1.

Dataset1 would be similar to this with a unique iGoalID for each group in the main tablix.

Dataset2 would look like this;

I'd like to be able to loop through DataSet2 and display the data, but only grouped by the main tablix iGoalID equaling dataset2's iGoalID

Solution

You have to build the subreport as a separate report .rdl and build it to accept a parameter of the ID. You will then pass the ID parameter to the subreport once it's added to the parent report. Once the sub is built, tested, and saved...add it to your main report using Insert-> Subreport on the main tab. You should be able to select the cell on the design view where you want the subreport to be and insert the subreport there.

To specify parameters to pass to a subreport

1. In Design view, right-click the subreport and then click Subreport Properties.
   1. In the Subreport Properties dialog box, click Parameters. Click Add. A new row is added to the parameter grid.
   2. In the Name text box, type the name of a parameter in the subreport or choose it from the list box. This name must match a report parameter, not a query parameter, in the subreport.
   3. In the Value list box, type or select a value to pass to the subreport. This value can be static text or an expression that references a field or other object in the main report.

Comments

[Nick G]

thank you lethal, i actually figured this out last night doing exactly what you described, thank you for putting it into words for me, one of those things that comes to you almost in your sleep ya know! This will definitely 100% help me in future .rdl reports

[Michael12345]

This sounds like it will do the trick, what I would add for anyone considering nesting a subreport in a tablix is that the performance can very quickly plummet as your row count or report complexity increases,