Lets say you have a report created using Report Builder 2.0, in my case and want to open the report in Business Intelligence Development Studio (BIDS) using Report Designer.

 There are umpteen number of places where they talk about the fact that you can open a report created in Report Builder using Report Designer, but exactly how to go about doing that is not provided.

 So, I had to go hunt for myself and am providing the steps to be able to do that.

  1. Go to the report using Report Manager, found at http://ReportServerURL/Reports
  2. Click the Properties tab across the top
  3. Click the Edit button under the Report Definition section
  4. Now you can save the report definition as a .rdl file
  5. Open the saved file in BIDS Project using Add Item functionality
Advertisements