Jump to URL - Passing Parameter Issue with special symbols

Hi Microsoft,
I've currently using the Jump to URL Syntax (see below) to open a new window
and pop up a drilldown report in IE.
The main problem i'm having with the syntax below iswhen the account manager
name (ACCTMGR Parameter string) contains a umlaut (german name with a double
o on top of a letter), the drilldown report runs but it doesn't run the
report details (report is blank) when information does exist. I've tried
search for resolutions online and cam up with nothing.
In addition, when a parenthesis and or an ampersand is present in the
parameter, it does not run the drilldown subreport. Your help would be
greatly appreciated.
Can you help?
=iif(sum(Fields!TotalAmount.Value)=0,"","javascript:void(window.open('http://ourreportserveralias/reportserver?%2fDrillDown+Reports%2fMarketing+Campaign+Report+Details&rc:Parameters=false&rptCurrency="
& Parameters!rptCurrency.Value & "&Division=" &
Join(Parameters!Division.Value, "&Division=") & "&DivSales=" &
Join(Parameters!DivSales.Value, "&DivSales=") & "&DeptSales=" &
Join(Parameters!DeptSales.Value, "&DeptSales=") & "&ProductLIne=" &
Join(Parameters!ProductLIne.Value, "&ProductLIne=") & "&startdate=" &
Parameters!startdate.Value & "&enddate=" & Parameters!enddate.Value &
"&ACCTMGR=" & ReportItems("ACCTMGR1").Value & "&CAMP=LEFT+BLANK" &
"','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=800,resizable=yes'))")My guess is you have to URL encode this. Here is a link. You might be able
to use HttpUtility.UrlEncode in your expression. However, if it doesn't then
you will need to use code behind reports.
http://weblogs.asp.net/psteele/pages/7509.aspx
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RS2005Developer" <RS2005Developer@.discussions.microsoft.com> wrote in
message news:2BDFEDDE-C685-4224-91A1-489DF67E757D@.microsoft.com...
> Hi Microsoft,
> I've currently using the Jump to URL Syntax (see below) to open a new
> window
> and pop up a drilldown report in IE.
> The main problem i'm having with the syntax below iswhen the account
> manager
> name (ACCTMGR Parameter string) contains a umlaut (german name with a
> double
> o on top of a letter), the drilldown report runs but it doesn't run the
> report details (report is blank) when information does exist. I've tried
> search for resolutions online and cam up with nothing.
> In addition, when a parenthesis and or an ampersand is present in the
> parameter, it does not run the drilldown subreport. Your help would be
> greatly appreciated.
> Can you help?
> =iif(sum(Fields!TotalAmount.Value)=0,"","javascript:void(window.open('http://ourreportserveralias/reportserver?%2fDrillDown+Reports%2fMarketing+Campaign+Report+Details&rc:Parameters=false&rptCurrency="
> & Parameters!rptCurrency.Value & "&Division=" &
> Join(Parameters!Division.Value, "&Division=") & "&DivSales=" &
> Join(Parameters!DivSales.Value, "&DivSales=") & "&DeptSales=" &
> Join(Parameters!DeptSales.Value, "&DeptSales=") & "&ProductLIne=" &
> Join(Parameters!ProductLIne.Value, "&ProductLIne=") & "&startdate=" &
> Parameters!startdate.Value & "&enddate=" & Parameters!enddate.Value &
> "&ACCTMGR=" & ReportItems("ACCTMGR1").Value & "&CAMP=LEFT+BLANK" &
> "','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=800,resizable=yes'))")|||Hi Bruce,
Thanks for the quick reply!
I've tried referencing System.Web.HttpUtility.UrlEncode (and also just
HttpUtility.UrlEncode) in the Jump to URL syntax as such:
=iif(sum(Fields!TotalAmount.Value)=0,"","javascript:void(window.open('http://myserveralias/reportserver?%2fDrillDown+Reports%2fMarketing+Campaign+Opportunity+Report+Details&rc:Parameters=false&rptCurrency="
& Parameters!rptCurrency.Value & "&Division=" &
Join(Parameters!Division.Value, "&Division=") & "&DivSales=" &
Join(Parameters!DivSales.Value, "&DivSales=") & "&DeptSales=" &
Join(Parameters!DeptSales.Value, "&DeptSales=") & "&ProductLIne=" &
Join(Parameters!ProductLIne.Value, "&ProductLIne=") & "&startdate=" &
Parameters!startdate.Value & "&enddate=" & Parameters!enddate.Value &
"&ACCTMGR=" & System.Web.HttpUtility.UrlEncode(ReportItems("ACCTMGR1").Value)
& "&CAMP=LEFT+BLANK" &
"','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=1200,resizable=yes'))")
But no luck it doesn't work. It actually doesn't recognize the UrlEncode
syntax and I've also added the Reference System.Web as well to ensure
everything was referenced properly.
I'm a little new to VB so if you don't mind, I would greatly appreciate it
if you can be a little more specific on what needs to be completed iwth the
code and show an example of how would i reference it in the Jump to URL
expression below?
Thank you in advance for your help.
"Bruce L-C [MVP]" wrote:
> My guess is you have to URL encode this. Here is a link. You might be able
> to use HttpUtility.UrlEncode in your expression. However, if it doesn't then
> you will need to use code behind reports.
> http://weblogs.asp.net/psteele/pages/7509.aspx
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "RS2005Developer" <RS2005Developer@.discussions.microsoft.com> wrote in
> message news:2BDFEDDE-C685-4224-91A1-489DF67E757D@.microsoft.com...
> > Hi Microsoft,
> >
> > I've currently using the Jump to URL Syntax (see below) to open a new
> > window
> > and pop up a drilldown report in IE.
> >
> > The main problem i'm having with the syntax below iswhen the account
> > manager
> > name (ACCTMGR Parameter string) contains a umlaut (german name with a
> > double
> > o on top of a letter), the drilldown report runs but it doesn't run the
> > report details (report is blank) when information does exist. I've tried
> > search for resolutions online and cam up with nothing.
> >
> > In addition, when a parenthesis and or an ampersand is present in the
> > parameter, it does not run the drilldown subreport. Your help would be
> > greatly appreciated.
> >
> > Can you help?
> >
> > =iif(sum(Fields!TotalAmount.Value)=0,"","javascript:void(window.open('http://ourreportserveralias/reportserver?%2fDrillDown+Reports%2fMarketing+Campaign+Report+Details&rc:Parameters=false&rptCurrency="
> > & Parameters!rptCurrency.Value & "&Division=" &
> > Join(Parameters!Division.Value, "&Division=") & "&DivSales=" &
> > Join(Parameters!DivSales.Value, "&DivSales=") & "&DeptSales=" &
> > Join(Parameters!DeptSales.Value, "&DeptSales=") & "&ProductLIne=" &
> > Join(Parameters!ProductLIne.Value, "&ProductLIne=") & "&startdate=" &
> > Parameters!startdate.Value & "&enddate=" & Parameters!enddate.Value &
> > "&ACCTMGR=" & ReportItems("ACCTMGR1").Value & "&CAMP=LEFT+BLANK" &
> > "','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=800,resizable=yes'))")
>
>|||I suggest creating a report with a single textbox in it. Set your expression
so you can see the result. Next read up on using the code behind reports:
Using Custom Code References in Expressions (Reporting Services)
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/13fa8c92-0471-4b2f-b97c-9ebbcb13797f.htm
Your expression will look like this:
=Code.URLEncode("This is a test")URLEncode is a function you have written
that takes a single parameter and returns the encoded string.-- Bruce
Loehle-CongerMVP SQL Server Reporting Services
"RS2005Developer" <RS2005Developer@.discussions.microsoft.com> wrote in
message news:AA9EC05C-F668-4E99-AB58-48968CF9E909@.microsoft.com...
> Hi Bruce,
> Thanks for the quick reply!
> I've tried referencing System.Web.HttpUtility.UrlEncode (and also just
> HttpUtility.UrlEncode) in the Jump to URL syntax as such:
> =iif(sum(Fields!TotalAmount.Value)=0,"","javascript:void(window.open('http://myserveralias/reportserver?%2fDrillDown+Reports%2fMarketing+Campaign+Opportunity+Report+Details&rc:Parameters=false&rptCurrency="
> & Parameters!rptCurrency.Value & "&Division=" &
> Join(Parameters!Division.Value, "&Division=") & "&DivSales=" &
> Join(Parameters!DivSales.Value, "&DivSales=") & "&DeptSales=" &
> Join(Parameters!DeptSales.Value, "&DeptSales=") & "&ProductLIne=" &
> Join(Parameters!ProductLIne.Value, "&ProductLIne=") & "&startdate=" &
> Parameters!startdate.Value & "&enddate=" & Parameters!enddate.Value &
> "&ACCTMGR=" &
> System.Web.HttpUtility.UrlEncode(ReportItems("ACCTMGR1").Value)
> & "&CAMP=LEFT+BLANK" &
> "','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=1200,resizable=yes'))")
> But no luck it doesn't work. It actually doesn't recognize the UrlEncode
> syntax and I've also added the Reference System.Web as well to ensure
> everything was referenced properly.
> I'm a little new to VB so if you don't mind, I would greatly appreciate it
> if you can be a little more specific on what needs to be completed iwth
> the
> code and show an example of how would i reference it in the Jump to URL
> expression below?
> Thank you in advance for your help.
> "Bruce L-C [MVP]" wrote:
>> My guess is you have to URL encode this. Here is a link. You might be
>> able
>> to use HttpUtility.UrlEncode in your expression. However, if it doesn't
>> then
>> you will need to use code behind reports.
>> http://weblogs.asp.net/psteele/pages/7509.aspx
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "RS2005Developer" <RS2005Developer@.discussions.microsoft.com> wrote in
>> message news:2BDFEDDE-C685-4224-91A1-489DF67E757D@.microsoft.com...
>> > Hi Microsoft,
>> >
>> > I've currently using the Jump to URL Syntax (see below) to open a new
>> > window
>> > and pop up a drilldown report in IE.
>> >
>> > The main problem i'm having with the syntax below iswhen the account
>> > manager
>> > name (ACCTMGR Parameter string) contains a umlaut (german name with a
>> > double
>> > o on top of a letter), the drilldown report runs but it doesn't run the
>> > report details (report is blank) when information does exist. I've
>> > tried
>> > search for resolutions online and cam up with nothing.
>> >
>> > In addition, when a parenthesis and or an ampersand is present in the
>> > parameter, it does not run the drilldown subreport. Your help would be
>> > greatly appreciated.
>> >
>> > Can you help?
>> >
>> > =iif(sum(Fields!TotalAmount.Value)=0,"","javascript:void(window.open('http://ourreportserveralias/reportserver?%2fDrillDown+Reports%2fMarketing+Campaign+Report+Details&rc:Parameters=false&rptCurrency="
>> > & Parameters!rptCurrency.Value & "&Division=" &
>> > Join(Parameters!Division.Value, "&Division=") & "&DivSales=" &
>> > Join(Parameters!DivSales.Value, "&DivSales=") & "&DeptSales=" &
>> > Join(Parameters!DeptSales.Value, "&DeptSales=") & "&ProductLIne=" &
>> > Join(Parameters!ProductLIne.Value, "&ProductLIne=") & "&startdate=" &
>> > Parameters!startdate.Value & "&enddate=" & Parameters!enddate.Value &
>> > "&ACCTMGR=" & ReportItems("ACCTMGR1").Value & "&CAMP=LEFT+BLANK" &
>> > "','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=800,resizable=yes'))")
>>