title: DevExpress report Main and Detail reports stored procedures
body: <p>I have to create an XtraReport with two sections; master and detail. For example, categories - is master and their products is detail:</p>
  
  <p>Category1</p>
  
  <ul>
  <li>Prod1 </li>
  <li>Prod2</li>
  <li>Prod3</li>
  </ul>
  
  <p>Category2</p>
  
  <ul>
  <li>Prod4 </li>
  <li>Prod5</li>
  <li>Prod6</li>
  </ul>
  
  <p>The problem is that both categories and relevant products come from Stored Procedures. So I have 2 stored procedures, the first master stored procedure is without parameters, the second detail store procedure has the parameter of CategoryId (that comes from first Stored Procedure). </p>
  
  <p>I can't find a way to set the CategoryId parameter value of the second stored procedure from the first stored procedure.</p>
  
  <p>In the stored procedure designer I can see this, but I can't set the parameter value to first store procedure ID.</p>
  
  <p><a href="https://i.stack.imgur.com/qg6Z1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qg6Z1.png" alt="enter image description here"></a></p>