So I continue to delve into the bowels of Report Builder 3.0. My last post was asking about how to create a report such that when I run it a number of pages are created, paging between each row of a query. So if I have a class of students, I want one report card printed per student.
I understand that to do that I have to have a table, and each row of that table will represent a student, and the printing of each row should be followed by a page break. I have done that, and it works with a simple example.
Now what I need is for each row to contain my report. The report is pretty complex, containing more than one type of item in it. So I can't just copy from the designer when I'm looking at my older rdl file (the one with the working report for one student) and plug that into the single cell of my table that has page breaks by row in my new report.
So what I am trying to do is to use the first report as a subreport to the second. I have submitted the first report to reporting services, and I have right clicked inside the single cell of my table and created a subreport. I then went to the properties of the subreport and chose the report from reporting services.
I also made sure that the new report which calls the subreport has all the necessary visible parameters defined as are needed in the subreport.
When I click on the Run button, I see the parameters, and enter the data that works in the older report when run by itself. I enter the necessary information and click on the View Report button. After chugging for a few seconds, I see the following:
Error: Subreport could not be shown.
I assumed that there was a sizing issue, so I made the report space, table cell, and subreport object larger than the subreport would end up being, but when I run it I get the same issue.
It could be that I haven't tied the outer report's parameter list correctly the subreports parameter list, but I don't see anything obvious for that, and in my reading I haven't come across that. That doesn't mean I didn't miss something mind you.
Can someone suggest something I'm doing wrong, or not doing? I am going to be researching this further, but I thought at this point it would be very helpful to have some hints.
Thanks for the help.