SSRS Report Builder - Subreport link

[ckrusen (Calvin Krusen)]

SSRS report: "Error: Subreport could not be shown"

First make the subreport in SSRS. In SSRS Builder, File → New, blank report Add New Datasource [image] In Data Source Props [image] In Connection Props: [image] (Note that #2 is the DB of the source data, not a report DB) Back in Datasource Props, Test Connection , then OK. Add Dataset [image] In Dataset props: [image] In Query Designer build the query to get the data of your subreport. Here’s an example to query the Part table, with PartNum being a paramter (whi…