Prev: How to toggle subreport visibility
Next: SQL 2008 x64 SP1 SSRS
From: Ed Staffin on 17 Mar 2010 16:00
We are using a SQL Server embedded connection and a specific user name and
password for the Report Server. Meaning not Windows Authentication.

When we use a report URL as the drill down from one report to another and
click on the link, we get the Report Server logon asking for User Name and
Password . Once we enter these the drill down report works fine.

We have tried to include the user name (dsu) and password (dsp) in the URL
below but cannot get it to work and need assistance in structuring the
Hyperlink expression. Also we would like to hide the address information so
the user cannot view it.

="javascript:void window.open
('http://mydomain.com/reportserver?/User+Reports/Staff+Utilization+Report&Server="&
Parameters!Server.Value &"&Database="&Parameters!Database.Value
&"&CompanyId="&Parameters!CompanyId.Value &
"&StaffId="&Parameters!StaffId.Value &"&Start="&Parameters!Start.Value
&"&End="&Parameters!End.Value & "&dsu:Parameters!Server.Value=" &"UserName" &
"&dsp:Parameters!Server.Value=" &"password" & "
&rs:Command=Render','_blank','resizable=1,toolbar=0,status=0,menu=0,top=20,left=20,width=1280,height=1024')"

 | 
Pages: 1
Prev: How to toggle subreport visibility
Next: SQL 2008 x64 SP1 SSRS