I have an existing report I set which has about fifty fields forty of which are shared by several tables. I wanted to create a base report with those fields added and formatted and then use a copy of that to report on the different tables.
The problem is when I change the dataset query it always breaks the report. I tend to get errors regarding the tablix sort orders and even after I delete everything it never works right.
Is there a way for me to change the dataset and then "refresh" the report to get is working with the new data?