Creating custom SQL reports

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).

Creating custom reports using Report Builder

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.

Note

To set up Report Builder 3.0, refer to the following links:

• http://www.microsoft.com/en-in/download/details.aspx?id=42301

• https://technet.microsoft.com/en-us/library/dd207038(v=sql.120).aspx

Once Report builder is successfully integrated, follow the ensuing steps to create a custom report to know the number of active work items per...