To create a new query using existing data source, follow the steps below:
- Open MS Excel
- Click Build DataSet
on Aspose.Cells.Report.Designer.
- In the dialog box, select a data source listed in the left panel, for example select SqlServer and click Add button.
- In the dialog box, type a new data set name, for example SalesEmps and click Next button.
- Aspose.Cells.Report.Designer will start MS Query and connect to the data source that was selected in the step 3. Users can create a new query in MS Query now.
- From Microsoft Query's File menu, select Return To Aspose.Cells.Report.Designer.
- Now the DataSource “SqlServer” contains two datasets, and one of them is the newly created dataset SalesEmps.