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

[ckrusen (Calvin Krusen)]

First make the subreport in SSRS.

1. In SSRS Builder, File → New, blank report

2. Add New Datasource
   

3. In Data Source Props
   

4. In Connection Props:
   

   
   
   (Note that #2 is the DB of the source data, not a report DB)

5. Back in Datasource Props, Test Connection , then OK.

6. Add Dataset
   

7. In Dataset props:
   

   

8. 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 (which will be passed from the main report)
   

   

I’m guessing you could even copy the Query phrase from BAQ Designer, and paste it right into the query phrase expression.

9. make the rest of your subreport

Now in your main report, reference that subreport you created, and set the relationships/links.