SSRS:(SSRS) report with drill down functionality.

------------------------------------------------------------------------------------------------------------------------


Refer the Source url:(SSRS) report with drill down functionality

------------------------------------------------------------------------------------------------------------------------

Summary:

Create the report using "Report Wizard" , in the process it will show an option for "Enable Drilldown", after choosing it the report will have drilldown feature.

------------------------------------------------------------------------------------------------------------------------

1.Programs->BIDS->Visual Studio 2008->

File-New Project->Report Server Project Wizard (Name:)

Shows Report wizard

-Shared data source - new datasource(name,connection string "Edit" button- )

[Make Shared DataSource]

Query Builder:choose Table-columns (shows Sql query)

Tabular Matrix (choose layout)

Group-

In the Table Layout choose below options

-Include subtotals -Enable drilldowns

Formatting -

Show the Report Server name


------------------------------------------------------------------------------------------------------------------------