Search code examples
reporting-servicessubreport

SSRS fails to render subreports after report and subreport are deployed

SSRS subreport does not display properly after deployment.

I've developed (modified actually) a report in SSRS (via Visual Studio). The report and subreports display properly in the VS report designer, but after I deploy the reports, the main report renders properly but the two subreports fail to render.

Any ideas?

subreports render correctly when run from Visual Studio, but not after being deployed

Solution

  • I would suspect your issue stems from the path used to reference your subreports in the .rdl. Typically, when developing a report on the local environment, it requires a full path to the subreport -- whether the .rdl for the subreport is saved on the report server or the local filesystem. In my experience, the full path typically breaks or becomes inaccurate when the files are uploaded to the report server. It is usually easier to use a relative path and store all .rdl files in the same folder on the report server. For example, the differences can be demonstrated as the following.

    Full path:

    https://server/site/library/folder/Report1.rdl
C:/Reports/AllSubreports/Subreport1

    Relative Path:

    ../AllSubreports/Subreport1
Subreport1

    This was often the issue with my reports, though yours could have other causes. Refer to this Microsoft documentation link for more information.