Drill-through report passing credentials

Is it possible to drill through to a report that does not have embeded credentials? Every time I link from a report that requires a sql username and password to run to another report that requires the same permissions, I recieve an error message stating: "One

or more data sources is missing credentials" Is there a way to make RS prompt the end user to re-enter credentials after drilling through to the next report, or to make the credentials entered to access the first report pass through to the second report? The drilling through works perfectally from within visual studio, but fails to work when the report is viewed in IE.Did you ever fix this problem? I am having the same problem. It works fine when run in Visual Studio but then on the server it does not prompt again for the credentials when drilling through to the next report. My email is scriptjunk3@.hotmail.com. If you did fix this or get an answer, please let me know here or at my email. Thank you.

Drill-through report passing credentials

Is it possible to drill through to a report that does not have embeded credentials? Every time I link from a report that requires a sql username and password to run to another report that requires the same permissions, I recieve an error message stating: "One or more data sources is missing credentials" Is there a way to make RS prompt the end user to re-enter credentials after drilling through to the next report, or to make the credentials entered to access the first report pass through to the second report? The drilling through works perfectally from within visual studio, but fails to work when the report is viewed in IE.
Did you ever fix this problem? I am having the same problem. It works fine when run in Visual Studio but then on the server it does not prompt again for the credentials when drilling through to the next report. My email is scriptjunk3@.hotmail.com. If you did fix this or get an answer, please let me know here or at my email. Thank you.

Drill through --relative path

I'm trying to use the drill-through feature to link to a report in different solution, on the same server, but in a different project. Local help files say: "The list of report names includes all reports in the current report server project. If the drillthrough report is on the report server but is not in the project, type the name of the report. The report name can contain a relative or absolute path to the report."

The report will be passing a parameter to the target report through drill-through. The target report is located on different solution and project but on a same server (report manager). Any help will be be appreciated.

Can someone give an example of a relative path? Nothing I've tried has worked, and I've posted this on sqlteam to no avail.

Thanks,

Lalon

if your base directory is "c:/SomeProgram/"

relative_path -> absolute path
"dir1/dir2" -> "c:/SomeProgram/dir1/dir2/"
"../dir3" -> "c:/dir3/"

i don't know what and how you are using the relative paths, but if you are using paths in directly in code, in some programming languages you have to double the '/' ("../dir3" -> "..//dir3")

Amaral