Display SubReport in same page with Master Report in SSRS 2008

Hello All,

I am developing a report , where the master report contains the anual performance report for KPI. There is one column for view details , on click on which will populate the subreport with some chart data. I need the subreport should populate just below the master report. However when I click on the View Details link , it os going to a separate report page (which is the sub report page). Can anyone please help me out how to do this?

Your suggesstion will be highly appreciated.

Thanks,

Aurosish.

In design view, drag the subreport into the cell where you want it to display.  Do this instead of linking to the report.

Hi Kathi,

I appreciate your suggestion. However I could able to solve this by below steps.

1. Drag and drop the Subreport outside of the main data table.

2. Design the Sub report as per the need.

3. In the Main report data field , select the Action -> Go To Report -> (Point to the Main report again)

4. Create a parameter default value as 0 and set it to 1 on the click of the data field on the Main Report.

5. Pass other parameter to the Sub report to execute the subreport.

Finally the Subreport will be displayed on the same page as Main report. As we have redirected to the same report on the Click Action.

Thanks,

Aurosish.

Hi

Could you please provide a tutorial of this solution or a link to a similar tutorial

Thanks in advance

aurosish said:

Hi Kathi,

I appreciate your suggestion. However I could able to solve this by below steps.

1. Drag and drop the Subreport outside of the main data table.

2. Design the Sub report as per the need.

3. In the Main report data field , select the Action -> Go To Report -> (Point to the Main report again)

4. Create a parameter default value as 0 and set it to 1 on the click of the data field on the Main Report.

5. Pass other parameter to the Sub report to execute the subreport.

Finally the Subreport will be displayed on the same page as Main report. As we have redirected to the same report on the Click Action.

 

Thanks,

Aurosish.