Adding base information for Table

To create a new table:

1. Open Microsft Excel.
2. Click Open Report

  on the Aspose.Cells.Report.Designer toolbar to open an RDL Report file that contains the data sources, datasets and Report Parameters created in advance. Once the file has been opened successfully all its information is available for use, for example, its datasets are listed in the relevant DataSet combo box.

1. Open a Microsoft Excel spreadsheet and design the table header as following:

   Designing the table header

1. Select a dataset ”EmpSalesDetail” from relevant dataset combo box control.

   Selecting a data set

1. All the fields of dataset ”EmpSalesDetail” are listed in the fields combo box. Select the cell under the OrderNumber column Cell and then select ”SalesOrderNumber” field from the fields combo box to insert a data marker into the cell.

   Inserting a field

The field code shows where a field has been inserted.

1. Repeat the step 5 to insert ProdCat and SubCat fields.

   All fields inserted