Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSRS not letting me change dataset of a table

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?

like image 354
iDesi Avatar asked Aug 09 '13 15:08

iDesi


1 Answers

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

like image 146
iDesi Avatar answered Nov 21 '22 17:11

iDesi