Change connection string from report execution init script or SWExecuteReportToResult method

[nickakin]

How can I change the connection string, or connection guid on the report execution from the report execution script? I see that I can set the data source connection on the user profile but calling it from the SWExecuteReportToResult method I don't have an option to set the data source connection. I am currently sending in a user identifier as the token and then querying my database for the user.

[ariacom]

Hi, I think you cannot change the connection using SWExecuteReportToResult, this would require an evolution of the API.

[nickakin]

I was attempting to change it using the Report Init Execution Script that would run when the report was executed, but I see that the code has logic to pull the appropriate connection. I am assuming it's just too far into the execution pipeline. Without changing the API, what is the intended way to use the multiple connections in a data source? It appears that I need create a security group for each connection string and then configure the security script to place the user in the appropriate group.

[ariacom]

Without changing the API, you can act only on: The default connection defined for the user (via his groups and profile), or the default connection of the report itself (that means to have a copy of the report with the wanted connection).
This can be made dynamically but depends on your control at the server side.
A last option would be to enhance the API to give a connection GUID.