We now have a little understanding about the purpose of SQL Server Reporting Tools. This section will walk you through the process of creating custom reports using Report Builder and Report Designer (Business Intelligence Development Studio).
Report Builder is a simple and easy report authoring tool for business users, which is supported by SQL Reporting services. Report Builder 3.0 provides the capability to design, execute, and deploy to SQL Server Reporting Services. The user interface has been streamlined to allow business users to become proficient at authoring reports very quickly.
To set up Report Builder 3.0, refer to the following links: