Create SUB-REPORT IN SSRS and pass the PARAMETER to sub-report

Create a sub report in SSRS

Step 1: Create a report and name it (My self Department Table is Subreport). In first dataset1 take all fields, in dataset2 take deptno from DEPT table, then pass the multiple values to parameter using IN CLAUSE at Query level.

 Step 2: Choose one of the report among those  (My_Child_table) as parent table, then right click --> Insert--> Subreport

Step 3:Go to subreport properties by right clicking on subreport wizard

Step 4:  In General settings under Use this report as a subreport From drop down select report(My self is subreport which is created recently )--> click OK

Step 5: Parameters --> Add-->Choose your parameter NAME( deptno)--> value from drop down list--> OK

Step 6: Click on preview and select deptno s -- [find the difference between two figures ]