title: Use code in a hidden detail row of RDLC
body: <p>I am troubleshooting an RDLC file created by a third party.  They've got some VB.NET code in the report, and an expression in the detail row is calling a function defined by the code.  The function doesn't return any data; it just populates an array.  There's nothing else in the detail row, and the row itself is hidden.</p>
  
  <p>In the footer of a summary group, there are two more expressions that call functions which use the array populated by the first function.  If the detail row is visible, those functions work fine.  If the detail row is hidden, the expressions return #Error. It doesn't appear to be calling the function, and the array is staying empty.</p>
  
  <p>I modified the detail row to be as small as possible, but there are quite a few rows being returned, so I'm getting quite a bit of white space.  <strong>Is there a way to hide the detail row and still have it call the function from the report code?</strong> </p>
  
  <p>I found the following question which seemed to be what I was after, but I don't think the respondents understood the question.</p>
  
  <p><a href="https://stackoverflow.com/questions/13910735/hide-a-row-in-rdlc-report-without-disabling-the-code-execution">Hide a row in RDLC report without disabling the code execution</a></p>
  
  <p>I'm using Visual Studio 2013.  I appreciate any suggestions.  Thanks.  </p>
  
  <p>EDIT:</p>
  
  <p>Here's the report Code section, if it helps clarify the situation.</p>
  
  <pre><code>public dim TranDate(0) as DateTime
  public dim CashFlow(0) as Double
  public dim BFCashFlow(0) as Double
  
  public dim RowCount as Int32=0
  
  Public Function PrepairCashFlowArray(byval myTrandate as Date,ByVal myCashFlow as Double,ByVal myBFCashFlow as Double)
  
  Redim Preserve  TranDate(RowCount)
  Redim  Preserve  CashFlow(RowCount)
  Redim  Preserve  BFCashFlow(RowCount)
  
  TranDate(RowCount)=myTrandate 
  CashFlow(RowCount)=myCashFlow 
  BFCashFlow(RowCount)=myBFCashFlow 
  
  RowCount =RowCount +1
  
  End Function
  
  Public Function GetNETIRR() as Double
  
  Return ((IRR(CashFlow, -0.1)+1)^4-1) * 100
  
  End Function
  
  Public Function GetGROSSIRR() as Double
  
  Return ((IRR(BFCashFlow, -0.1)+1)^4-1) * 100
  
  End Function
  </code></pre>
  
  <p>Here's the detail row expression.</p>
  
  <p><code>=code.PrepairCashFlowArray(Fields!perfdate.Value,Fields!cashflow.Value,Fields!bfcashflow.Value)</code></p>
  
  <p>Here's one of the two summary row expressions (they're similar).</p>
  
  <p><code>="Net of Fee IRR: ="&amp;format(code.GetNETIRR(),"##,#0.#0")</code></p>