What is the easier way to rename the Data Sets in completed SSRS report? I have created a report in BIDS 2008 and now for some reasons I have to rename the Data Set names, but it seems that renaming the Data Sets in the Report Data pane, does not update the references wherever the old DataSet name has been used.
For example I have DataSet1 and want rename it to Abc. Do I have to go through all text boxes and expressions that have used the old name and rename them to the new Data set name manually? Or there is a short cut to keep them in sync.
Any idea?
Thanks.