title: In SSRS, is it possible to loop one subreport rdl from a master rdl without using C#?
body: <p>I'm having a problem using a subreport inside a Master page.  My Master page has 4 parameters with one parameter that varies.</p>
  
  <p>The one subreport inside the Master page will take 3 parameters that are constant and the 4th parameter will change by way of a loop.  The output will create many reports generated from the 4 parameter.</p>
  
  <p>How do you create a loop from the Master page changing the value of the 4th parameter to run the subreport as many times as there are values in the 4 parameter?</p>
  
  <p>The Main Report (Main.rdl)
  Parameters
    WidgetID
    RegionID
    TimePeriodID</p>
  
  <p>The query will get the distinct StateIDs</p>
  
  <p>The SubReport (subreport.rdl)
  Parameters
    WidgetID
    RegionID
    TimePeriodID
    StateID</p>
  
  <p>The report has 5 lines of headers with all of the parameters in the header, including the first state name.  The detail line with have all of the widget information inside that state.</p>
  
  <p>Then loop to get the next StateID and repeat the output as before.</p>
  
  <p>Then continue until all of the StateIDs are processes.</p>
  
  <p>I cannot group by State since that has to be in the header.</p>
  
  <p>Taking the advice from Dominic I tried to follow his instructions.</p>
  
  <p><strong>Main.rdl</strong></p>
  
  <p>Created a Table via Toolbox and put the subreport in the first data column.</p>
  
  <p>Added 3 Parameters</p>
  
  <p>Dataset output</p>
  
  <p><strong>SubReport.rdl</strong></p>
  
  <p>Added 3 Parameters</p>
  
  <p>Dataset output</p>
  
  <p>When I Preview Main1.rdl, I get the first row and then new page.  Second row and then new page.</p>
  
  <p>What I am trying to get is a new page after change in State Code.</p>