title: SSRS call stored procedure using ReportItems! textbox. Maybe custom report code?
body: <p>I need to call a stored procedure during my report to insert values into a table. These values are the result of fields from the dataset added. For example, I have a row of values, and the far right column is <code>"ReportItems!TextBox1.Value + ReportItems!TextBox2.Value ..."</code> This gives the correct total on the report. Now I need to call a procedure using this value as a parameter.</p>
  
  <p>Using a stored procedure as a dataset, I am unable to reference the <code>ReportItems</code>! I am also unable to create additional report parameters (even internal or hidden) which could be a result of a dataset due to the reporting infrastructure we are using.</p>
  
  <p>I know using custom report code, I can call a stored procedure and also reference the <code>ReportItems</code>, but I have been unable to find the correct syntax. I am not familiar with VB.net so please be specific. If i could get an example of how to call: <code>Procedure TEST_INSERT(ReportItems!TextBox1.Value)</code>, I would be able to figure out how to implement it.</p>
  
  <p>I am using an oracle backend as my data source.
  Thanks</p>