SSRS Dataset move up and down

There is no way to Move up and down datasets on the reports designer

(Even though there are up and down arrows that seem to allow such move)

These buttons are only used to move up and down fields in a specific DataSet.

However, there is a solution to do that:

Open a report in view code (right click on your report and click view code)

This will open your report in an XML View

Search for the <Datasets> tag. (Or : <DataSet Name=”YourDataSet”>)

You can contract the dataset list to display a single line per dataset

Cut the selected line and paste it where you would like it to be

Reopen your report in view designer and the dataset would be where you want.

This entry was posted in SSRS and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s