Make a backup first!
In the menu: View-Code. This will lead you into the XML representation of your report.
Find the <Datasets>
. Select the dataset to move by removing from the <DataSet NAME="MyDataSet">
closing tag </DataSet>
. Insert wherever you want. Your datasets will be reassigned to the dataset drop-down list.
In the View-Designer menu, return to the report designer.
source share