SSRS not letting me change dataset of a table

Question

I have a report with a table in it. I need to change the dataset that this table uses. When I go the tablix properties and try to change the DataSetName, it automatically gets reverted back to the original dataset instead of the new one I selected.

Any ideas on how to fix it and why it's happening?

Erk

That is a really weird problem. Have you checked that the dataset is shown in the Report Data (View -> Report Data). Also, are your bindingSources correctly connected? – Prosit

Does the new dataset name contain any illegal characters? – Recorder

I figured it out. Turns out that whoever designed the report, had the entire report inside a table with one gigantic column, that column had a rectangle which contained the entire report. So obviously my table kept inheriting the datasource from the root table. I took out the needless table and rectangle, and the report now works as desired. Thanks guys for trying to help, much appreciated :) – Erk

@Mogambo, you should post the comment as an answer. definitely helped the SSRS newbie here! – Hopeless

@Hopeless done! I'm glad it helped you out. – Erk

cool, here is 15 pts! ;) – Hopeless

Answer 1

I figured it out. Turns out that the entire report was inside a table with one gigantic column. That column had a rectangle which contained the entire report. So obviously my table kept inheriting the datasource from the root table. I took out the needless "root" table and rectangle, and the report now works as desired. Thanks guys for trying to help, much appreciated :)

Erk

Came here looking for some answers and this one worked straight away. Crazy how we tend to overlook small things. Cheers. – Laugh

Answer 2

If you have your tables(or matrix) inside one List as I did, this will also not allow you to set different datasets to each table.

Removing the List worked for me.

Rotten

Answer 3

I came across the same kind of issue, but i was able to overcome by below mentioned way.

I've created a sub report and placed rectangle inside the sub report with page break option checked before and placed all my sub report content inside the rectangle. This page break works only if the sub report renders any data if not they will be no page break.

Tintinnabulum

Answer 4

If you edit with Notepad++ or something similar you can see that it is just an XML. You can alter the DataSet from the text editor and reopen.

Heritor