title: Table in Excel from SQL Server stored procedure with parameter field in workbook
body: <p>I need to create a dynamic report using Excel 2010 and SQL Server. Going off of previous ones created by others I figured out how to create the data connection and use the stored procedure with a specific parameter in the connection properties definition tab. The other reports use a <code>?</code> in the command definition and use a cell in the workbook to define the parameter. </p>
  
  <p>How do I do that too?</p>
  
  <p>Specific steps to creating the connection/report/parameter selection or any help much appreciated.</p>