Hi there,
My company has a centralised user profile repository that all new applications worldwide use for authorization and user details; we access it from the various apps via a web service.
What I'd like to do in a report is to pass a user's ID to the web service and return their name and contact details to display in the header. I imagine I'd need to do this in a custom function and I can see where I can add a reference to use in this function but not where to add a web reference. Is this possible?
Regards,
Uzum4k1i.
One possible solution to the issue is to add custom code to the report: custom code (e.g., a C# library project in which a web reference could be added) calls the web service and exposes the web service call result for the report to reference. the assembly containing custom code needs to be deployed on the report server. More details are available here:
http://msdn2.microsoft.com/en-us/library/ms252130.aspx
Another possible option is to configure the web service as an XML data source in which the web service URL is the connection string. Details here:
http://msdn2.microsoft.com/en-us/library/ms159741.aspx
http://msdn2.microsoft.com/en-us/library/ms345338.aspx
|||Cheers Tau Liang, both of those answers sound like they'll fit the bill nicely
No comments:
Post a Comment