thx, our evidence is that giving them the same shared ds doesnt do the trick.
all datasets and t-sql scripts in master and sub using the same session
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?
2 additional answers
Sort by: Most helpful
-
Joyzhao-MSFT 15,591 Reputation points
2020-08-19T05:49:18.11+00:00 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 -
Joyzhao-MSFT 15,591 Reputation points
2020-08-26T02:37:50.657+00:00 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.