<p>Hi</p>
<p> </p>
<p>I have built a report with SQLEXPRESS data source. The column structure of database View is as follows:</p>
<p>IDX, DATE, SIGNAL, Value</p>
<p> </p>
<p>Let us say there are 10 types of signal in the table view. I want a computed field that computes as follows:</p>
<p>COMPVAL=Sig9+Sig10-Sig8.</p>
<p>Singal1 to Signal7 retain their original value.</p>
<p>How to do this at Datasource level and at Chart level.</p>
<p>I tried the Computed column but field list shows the same columns as mentioned above as the View headings.</p>
<p> </p>
<p>Please suggest solution</p>
<p> </p>
<p>Regards,</p>
<p>Ram</p>
<p> </p>
