Thursday, December 6, 2012

SSRS Reports - Passing Parameters to Subreports in Sharepoint


If using SSRS on Sharepoint


  • After inserting the subreport, in the Subreport Properties, in the "Use this report as a subreport" field, remove the location, and just put the name and internal directory structure of the subreport you want to use.
  • By default, sharepoint will put the long url location of the subreport. The designer will not detect the subreport properly, and you will not be able to pass any parameters to it.

For all other details on passing parameters, check out these articles
http://www.katieandemil.com/ssrs-create-subreport-with-parameter-example-tutorial-ssrs-2008-r2
http://andreaswijayablog.blogspot.com/2011/04/ssrs-repeat-subreport-with-multivalue.html


No comments:

Post a Comment