November 14, 2012 at 4:35 am
HI All,
For eg: I have two reports - report1 and report2
I am navigating from Report 1 to report 2 using jump to URL option by passing paramaters..
There are few paramaters with special symbols like '&' and cause of those paramaters I am not able to navigate/drill down to the report 2.
="http://servername/ReportServer/Pages/ReportViewer.aspx?%2ftest+1%2ftestds%2fReport2&rs:Command=Render&ReportParameter1=" & JOIN(Parameters!ReportParameter1.Value, "&ReportParameter1=")
The above jump to URL option is used and it works fine if I ignore paramaters with special symbols
Could anyone please let me know how to handle specials characters in JUMP to URL option in ssrs?
Thanks in advance!!
November 14, 2012 at 5:24 am
Why are you using the Jump to URL option and not the Jump to Report option and using parameter pass through?
Report in a different solution, report on a different server?
November 14, 2012 at 5:34 am
When using Jump to Report option:
When I navigate from Report 1 -> report 2 using drill through mechanism , the paramaters tab gets hidden automatically when the reports are deployed...everytym got to click the button to show/hide parameters in the deployed reports
So I wanted to go for Jump to URL option where the paramater tab would be visible always...
Any help on this?
November 14, 2012 at 6:30 am
A quick google search found this blog, which seems a reasonable way:
http://capstonebi.blogspot.co.uk/2010/04/url-encoding-in-reporting-services.html
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);November 14, 2012 at 6:53 am
Thanks, I had already tired this...... not sure where to set the step 3 given as an expression in the report.... It shows #Error when I place it in text box expression...
I don know how to include some expression with the report url which escapes the special symbols
November 14, 2012 at 6:56 am
="http://servername/ReportServer/Pages/ReportViewer.aspx?%2ftest+1%2ftestds%2fReport2&rs:Command=Render&ReportParameter1="
& UrlEncode(Parameters!ReportParameter1.Value)
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);November 14, 2012 at 8:43 am
IF I try embedding the URL encode function with the jump to URL link,I am not able to jump to url...i.e it throws error internet cannot display the web page...
looks like paramaters are not being passed...
November 14, 2012 at 9:01 am
Show us the code you use in the expression that builds the hyperllink and also copy the generated hyperlink from the rendered report and show us that.
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);November 15, 2012 at 2:24 am
Hi,
I have changed the URL and it works fine now but there is another problem that exists.
Below is the link I used in JUMP URL Option
="http://servername/ReportServer/Pages/ReportViewer.aspx?/test/test/Report2&rs:Command=Render&ReportParameter1=" & code.urlencode(JOIN(Parameters!ReportParameter1.value, "&ReportParameter1="))
The above hyper link works fine and it jumps to the Report 2.and any paramaters with special symbols are handled.... If I just select one paramater in report one and navigate using the URL option, the selected paramater is passed and report 2 is generated.
Below is the hyper link for it:
'New York' is the parameter selected and being passed to report2.... But when I click more than 2 paramaters and then try navigationg to second report, the reportparamater1 in Report2 doesnt is blank...the parameters are not being passed.....
It has to be '&ReportParamater1' but the function converts to %26 and this may be d reason...ANy help on this??
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply