For a table report, users have to setup report attributes before publishing report to Report Server. Report attributes contain information about report name, range, data grouping, data sorting and so on.
To setup the attributes of a table report, follow the steps below:
- Click Set Attribute
on the Aspose.Cells.Report.Designer toolbar. Input report name i.e., “EmpSalesDetail” in the dialog box and click Next button.
- Select the report range which starts with the first cell of table data row and ends at the last cell of footer data row(s) (or group data rows if footer data row(s) do not exist). The index of the start cell and index of the end cell will appear in the Range text box automatically. In the sample the range includes cells from D4 to H8. Click Next button to continue.
- All the fields of the dataset are listed in the left panel in the dialog box. Select some fields for group by clause and click Next button to continue.
- In the dialog box, select some fields for order by clause and click Next button.
- Click Finish button to complete the work.