To edit a query in Aspose.Cells.Report.Designer, follow the steps below:
- Open MS Excel
- Click Build DataSet
on the Aspose.Cells.Report.Designer toolbar.
- In the dialog box, select a dataset listed in the left panel, for example, EmpSalesDetail and click Edit button.
- Aspose.Cell.Report.Designer will start MS Query and open the query in MS Query for editing.
- From Microsoft Query's File menu, select Return To Aspose.Cells.Report.Designer