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