October 26, 2009 at 3:21 am
I have a report that uses a shared data source with no stored credentials. It is called with user supplied credentials from an application by using the query strings dsu and dsp. It works fine.
But when this report itself then opens a drillthrough report (which uses the same shared data source), the drillthrough report asks the user for credentials. It seems that credentials are not passed to the drillthrough report.
How can I solve this problem? Ideally, I want the first report to use the credentials supplied to it, to open the drillthrough report using the same credentials.
October 27, 2009 at 1:24 am
Anyone?
October 28, 2009 at 5:17 am
Instead of using the "jump to report" option for the action, use the "jump to URL". It's not as simple as using the report option, and you'll have to manually build the URL (using an expression to include the appropriate parameters, and pointing to <server>/ReportServer/), but you'll be able to add the dsu and dsp parameters to the URL.
It's a similar solution to when you want to open a drillthrough report in a new window, as detailed here:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply