Is It Possible for Me to Include a Sub Report in a Tablix Row That Is Grouped by an Id

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

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.

Need to bind two dataset to a tablix. Please find image in description, how to achieve this kind of structure in SSRS

You can only bind a tablix to one dataset. The only way you can do this is to either

1. combine the data in your dataset query or, if that is not possible
2. use the LOOKUP() function to get the required data from your second dataset

You can read more about LOOKUP() here

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/report-builder-functions-lookup-function?view=sql-server-ver15

Related Topics