January 20, 2011 at 12:25 pm
I have been trying to set the action of a table cell to Go To URL and modify the URL to open in a new window, a la http://www.mssqltips.com/tip.asp?tip=1283 and http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/5efe07a6-1ff3-4bfa-baf3-717f7f431c6f with no success. Have others had this issue, and have you found a workaround?
My link works to jump to the other report if I just give the URL with the parameter value, but adding any combination of window.open() causes the link to simply not work (i.e. does not open anything or navigate to anything).
I'm accessing through the Report Manager from a webpart where the reportserver is running in Native Mode, transitioning to Integrated mode is probably not an option for me.
Thanks,
Jon
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
October 4, 2011 at 11:37 am
I got a report to open in a new window using javascript by doing the "Go to URL" action and then setting this expression (objects to fill in are between "<" and ">" signs. also you may have to take the spaces out between the words javascript and the colon. I had to put spaces in there for the post here to take it):
="javascript : void(window.open('<enter URL here>&rs:Command=Render&<Param Name>=" + Parameters!<ParameterName>.Value "','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=800'))"
The problem that I encountered with this method was that if I wanted to dynamically set a second value in this string such as:
="javascript : void(window.open('<enter URL here>&rs:Command=Render&<Param Name>=" + Parameters!<ParameterName>.Value +"&<Parameter2>="+Fields!<FieldName>.Value + "','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=800'))"
The drillthrough link will break. in my case I am trying to drill from a specific field that the user hovers over on a chart. Clicking on that item will cause a new window to pop up with a detailed report for that item. The first parameter in the link is a date that is set for the entire page so it is just passed through from the parent report to child report but since the second param is for whichever item the user chooses to click on, I cannot set it as a parameter in the first (parent) report. The second parameter required for the child report is a field in the parent report.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply