To add Reporting Services Formulas to the table data cell, follow the steps below:
- Make the table data cell selected and Click Insert Formula
on the Aspose.Cells.Report.Designer toolbar.
- Select “DataSet” in the left panel, select “EmpSalesDetail” in the middle panel and double click “Sum(EmpSalesDetail.OrderQty)” in the right panel. A formula expression appears in the top edit box. Click OK button to insert the expression to the cell.
- The result is shown in the following.
- Repeat the steps above to add formula to Sales column, as shown in the following.
