all datasets and t-sql scripts in master and sub using the same session

Question

hi i am involved with a front end technology that sends a request to my master report.

the subreport's multiple t-sql scripts and one proc MAY need to use the same sql engine session started by the master's proc. there is plumbing back to the front end "session wise" from the sql engine that i'm just getting my head around. the master calls the sub multiple times.

can a connection started by a master report be used also in a sub that is "called" multiple times?

Answer 1

thx, our evidence is that giving them the same shared ds doesnt do the trick.

Answer 2

Well, then there is not much others we could do from SSRS side. I thinks we could not restrict master and subreport to use one session since they open different connections for themself.
If your problem has been solved, please mark "accepted answer" on my reply, thank you for your understanding.

Answer 3

Hi,
As I understand , for executing multiple reports , each report will open a new session when they are pull data use their own datasource.
IMHO master report and subreport can't have same session. You could try make them use same shared datasource, see if this works.
Regards,
Joy