8

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?

iDesi
  • 692
  • 1
  • 10
  • 19
  • 1
    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? – Shruti Kapoor Aug 09 '13 at 17:40
  • Does the new dataset name contain any illegal characters? – Eric Hauenstein Aug 10 '13 at 12:31
  • 1
    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 :) – iDesi Aug 13 '13 at 15:31
  • 1
    @Mogambo, you should post the comment as an answer. definitely helped the SSRS newbie here! – Illuminati Sep 24 '14 at 23:31
  • @Illuminati done! I'm glad it helped you out. – iDesi Sep 26 '14 at 14:53
  • cool, here is 15 pts! ;) – Illuminati Sep 28 '14 at 21:32

4 Answers4

24

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

iDesi
  • 692
  • 1
  • 10
  • 19
  • 1
    Came here looking for some answers and this one worked straight away. Crazy how we tend to overlook small things. Cheers. – Kashyap MNVL Sep 19 '16 at 14:57
1

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.

Pepys
  • 981
  • 7
  • 16
  • 34
0

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.

kenorb
  • 155,785
  • 88
  • 678
  • 743
siddharth
  • 19
  • 1
0

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.

radu
  • 35
  • 6