Targeting Sub Report on Sharepoint Server

  • Hello,

    I'm trying target a report that has been previously deployed to the report server (share point mode) as my sub report.

    In BI development studio the 'ReportName' property contains a drop down of other reports in my solution but not reports previously deployed.

    Is it possible to target a report on the server for example using the url to the report?

    I've tried "http://server/site/library/folder/TargetReport.rdl" as the ReportName but get an error to the tune of:

    The subreport 'mySubreport' could not be found at the specified location server/Site/Library/Folder/SubFolder/TargetReport.rdl. Please verify that the subreport has been published and that the name is correct.

    Is it possible to reference a sub report this way?

    G

  • It appears it is not possible in SharePoint integrated mode; only in native mode.

    http://msdn.microsoft.com/en-us/library/ms160348%28v=sql.100%29.aspx

    For a report published to a report server configured for native mode, use a full or relative path to the report, without the file name extension. If the report is in the same folder as the current report, use the name of the report only. If the report is in a different folder, use a relative path to the report (for example, ../Reports/DetailReport).

    For a report published to a report server configured in SharePoint integrated mode, use the name of the report including the file name extension (for example, DetailReport.rdl). The subreport must be in the same folder as the main report. Relative paths are not supported.

    G

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply