title: calculating sum in crystal report in textobject
body: <p>i want to display some records in a crystal report. for that i need to calculate sum fields . i need to calculate the sum of a field in sql table and i need to use where clause on that. 
  in fomula section of the crystal report i write </p>
  
  <pre><code>{open}+{{#RTotal1}- {#RTotal0}}  
  </code></pre>
  
  <p>which gives error. the open is a textobject. where i go wrong in this. </p>
  
  <p>the value of open Itextobject is passed from a textbox of the vb form by using this </p>
  
  <pre><code>DirectCast(GL2.Section2.ReportObjects("open"), CrystalDecisions.CrystalReports.Engine.TextObject).Text = TextBox8.Text
  </code></pre>
  
  <p>i think the problem is formula between textobject and fieldobject . where i go wrong nd what should i do.  </p>