Connecting Report Builder to Reporting Services
During the installation of Report Builder, you were asked the address of your SSRS Web Service URL. This was an optional step, and you might have skipped over it.
If you plan to run all of your reports in Report Builder, and never deploy them, then entering this information is not important. However, it is much more likely users will wish to generate reports, and then share them with coworkers via SSRS Report Portal. Thus, they will need to enter this into Report Builder.
In addition, they may need to update this address depending on what server the reports will be deployed to. It is quite common to have multiple SSRS servers set up within a larger enterprise, serving various departments or locations.
Getting ready
Make sure you have the Web Service URL for SSRS (to look up the web service URL, see the recipe in Chapter 3, Advanced Report Authoring with SQL Server Data Tools ). Note that the web service URL is different from the Report Portal...
