Difference Between Report Builder in SQL Server and Reporting Services in VS

Question

Hey im trying to get my head around the following , what is the difference between Report Builder in SQL Server and Reporting Services in VS ?

They seem to have both different wizard design screens i.e. one built into SQL Server the other one you can build in Visual Studio....do they both have the same end results etc ?

Thanks in advance

Answer 1

Report Builder is an end-user tool while the BI tools in Visual Studio are for the developer and can utilize the full capabilities of SSRS.

No, they don't have the same results. You can do vastly more with Visual Studio. Builder is primarily for very basic reports, though a user can get somewhat creative, but it's nowhere near the full capabilities that BI in VS unleashes.