Order of execution of 2 datasets based on webservice calls

• vsempoux

  SSC Rookie

  Points: 28

  More actions

  February 12, 2014 at 6:58 am

  #283699

  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

• eric.muller

  SSCommitted

  Points: 1998

  More actions

  February 13, 2014 at 10:22 am

  #1688852

  Try looking at this thread, it looks like it addresses a similar situation:

  http://www.sqlservercentral.com/Forums/Topic966325-150-1.aspx

  Good luck!

  ~EJM