I continue to have trouble getting a subreport to display from within a main report that is stored in a SharePoint Foundation 2010 document library. My report server is configured in SharePoint Integrated Mode.
A TechNet article, Specifying Paths to External Items (Report Builder 3.0 and SSRS) [http://technet.microsoft.com/en-us/library/dd220423.aspx], includes the following instructions:
When you specify a path for an external item in a dialog box for actions, subreports, or images, you can browse directly to the report server and select the item. Browsing to an item and selecting it directly is the recommended way to specify
a drillthrough report or subreport. That way the correct parameter names will be available in a drop-down list when you specify report or subreport parameters. When you change an item path to point to a different item, you must manually update the correct
parameter names and values as needed.
On a report server configured in SharePoint integrated mode, you must include the file extension .rdl. The path can be one of the following:
- A full path to the item. On a SharePoint site: You must specify the report name in an expression, with the full URL of the item and the file extension .rdl. For example, ="http://server/site/lib
View Complete Post