How to create a basic SQL Server Reporting Services project with drill down functionality using the Report Wizard. The demonstration uses Business intelligence Development Studio (BIDS) to launch the SQL Server Reporting Services wizard and create a report through a series of simple steps. The demonstration involves 1) creating a new data source (shared in this case) 2) editing a connection string to point to link the report to a SQL database table. Then 3) the graphical query designer is used to identify the fields that are required in the report. The 4th and final step involves identifying the report type we wish to use (Tabular or Matrix), the level of grouping required, & whether subtotals and drill through is needed).

I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-...