Try the following code in your jobstep on both servers.

if (select

ars.role_desc

from sys.dm_hadr_availability_replica_states ars

inner join...

Edit each (sub)report and add a parameter to it.

Name: pServername

Prompt: It's hidden so it does not really matter:)

Data type: Text

Visibility: Hidden

Add an embedded data source to the (sub)report

Value: ="Data Source="...

BL0B_EATER (9/3/2015)

---

For each connecting report ( from the main page) you will need to pass in the @servername as an “action”..

See screen shot.

This is how I passed in the servername...

David Stokes (8/25/2015)

---

Hey Arun, Thanks for putting this out there! I set this up in my environment but when I select a server from the drop down the report...