Analytics in Action

How to create a basic SQL Server Reporting Services project with drill down functionality using the Report Wizard.

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

 

 

admin