Passing parameters to SSRS

Question

I have 5 reports that I need to display on separate pages of an Excel workbook, so I created the main report and intend to call them nested reports. This works fine, but the problem is that I need to manage the name of each sheet, and I think the trick here is to use a rectangle and set the PageName property to the desired worksheet name.

The problem is that as soon as I put the nested records inside the rectangle and add the page break or page name when I run the main report, I get the error One or more parameters were not specified for subreport _____

The same thing happens if I put an auxiliary report inside the list.

How to pass parameters through a rectangle or name sheets without using a rectangle?

I am using SSRS 2008R2

Answer 1

I got to this, and this is apparently the weirdest SSRS error. When you move the sub file inside a list or rectangle and add a page break, SSRS flips the date format of the date parameters and, therefore, you end the transfer of values ​​that SSRS does not recognize as dates.

Even more obscure. If you pass the date values ​​so that the report succeeds, the next time you run it, SSRS will flip them the other way, and then they will remain flipped that way until you exit the report.

Return to the report and repeat the steps above. I will bring this up to Microsoft Connect.