SSRS not letting me change dataset of a table

reporting-services ssrs-tablix
iDesi picture iDesi · Aug 9, 2013 · Viewed 13.9k times · Source

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?

Answer

iDesi picture iDesi · Sep 26, 2014

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 :)

Related questions

Tablix: Repeat header rows on each page not working - Report Builder 3.0

I have a tablix with lots of rows that span over multiple pages. I have set the Tablix property Repeat header rows on each page but this does not work. I read somewhere that this is a known bug in …

Read More
SSRS How to repeat the table header on each page in print preview

I have an SSRS report, for some reason the header is not repeating on all of the pages in the print preview mode. Below is the image of the table: I have as well checked the Repeat Header rows on …

Read More
How to check if SSRS Textbox is empty

How do you check if a textbox is empty in SSRS 2008? I've tried this code and it doesn't work. IIF(ReportItems!txtCountVolunter.Value = "", false, true)

Read More