Hello,
I have a report that uses multiple datasets :
- 2 SQL datasource
- 2 web service datasource.
All datasets are integrated into the single report.
The problem i'm facing now is that dataset4 (webservice call) needs to get a value that is generated in dataset3 (webservice call).
This is due to security restrictions that the server which hosts the webservices can only handle a sessionid which is generated from the same server that is calling the webservice server.
So dataset3 is used to call the webservice server and gets a sessionid in return which i need to use into dataset4 which calls the data.
I have already found several threads on this issue, but always in combination with SQL server serialisation configuration, never with XML serialisation.
Can anybody point me into the right direction ?
If it's not clear i'll give more explanation if needed.
Thanks