title: SSRS - Auto Refresh of the Data Set Fields
body: <p>We have about 90 Report Builder Reports built by power users. These reports are built off the 20 odd Base reporting tables. </p>
  
  <p>Once in a while we add new fields to these reporting tables. </p>
  
  <p>The challenge here is to automatically refresh the Datasets in Report Builder (SSRS) without having to go through each report to manually refresh data on the data set. Since SSRS processes these reports with FMTONLY ON is there a way to automate this process dynamically.</p>
  
  <p>Thanks</p>