While working with ReportBuilder 3 there are times when we will move datasets around in SSRS, and old choices made when users connect to those datasets while using ReportBuilder 3 are invalid or just not there. But the choices remain in ReportBuilder 3! When you want to connect to these datasets, which may have the same name but just be in a different place, it’s frustrating for both the user and you. Here’s how to remove those old dataset pointers/shortcuts from the “Choose a DataSet” window:
- Navigate to C:users<username>AppDataLocalMicrosoftReport Builder10.50.0.0
- Locate the user.config file and open in notepad.
- About halfway down you will find the <RecentItem> elements under <RecentDataSets>. Remove the entire element you don’t want in there anymore. Note the path under the ItemPath attribute in each element to make sure you remove the correct ones.
- Save the file and restart ReportBuilder 3