Jump To URL issue
in [Reports]
|
Prev: 64 bit SRS – Using an ODBC Connection to an Access Database
Next: Background Color from SSAS cube on table's grouped rows
From: TheOriginalStealth on 26 Jan 2010 17:44 Report A jumps to Report B...good Report B opens in new window...good I have a parameter input box in Report B that is supposed to get populated from parameter in Report A...Not working. 1. How do I make this work 2. Is this efficient or is there a better way of doing this? 3. I did jump to report but couldn't open it in a new window. Help? 4. Also when REPORT B opens, parameters need to be hidden, and subscription stuff needs to be hidden ="javascript:void(window.open('http://ReportServer/Reports/Pages/Report.aspx?ItemPath=%2fReports%2fWork_Orders_Past_Due&DEPT_ID= 6)','','width=1000,height=600'))" thanks in advance
From: Bruce L-C [MVP] on 27 Jan 2010 10:08 Read up on URL Access in Books Online. You can collapse the different parts of the report window like the parameter areas. But keep in mind they can expand it if they want to. Jump to report will not open in another window, you were right to use Jump to URL. My guess on why the paramter is not filling in is because of case sensitivity. Check the parameter in the report and make sure that you have it exact including case on the URL. -- Bruce Loehle-Conger MVP SQL Server Reporting Services "TheOriginalStealth" <TheOriginalStealth(a)discussions.microsoft.com> wrote in message news:54E4FD63-BC5C-41FB-B039-9B2280568EB2(a)microsoft.com... > Report A jumps to Report B...good > Report B opens in new window...good > I have a parameter input box in Report B that is supposed to get populated > from parameter in Report A...Not working. > > 1. How do I make this work > 2. Is this efficient or is there a better way of doing this? > 3. I did jump to report but couldn't open it in a new window. Help? > 4. Also when REPORT B opens, parameters need to be hidden, and > subscription > stuff needs to be hidden > > ="javascript:void(window.open('http://ReportServer/Reports/Pages/Report.aspx?ItemPath=%2fReports%2fWork_Orders_Past_Due&DEPT_ID= > 6)','','width=1000,height=600'))" > > thanks in advance
From: TheOriginalStealth on 27 Jan 2010 13:55
Thanx Bruce. After playing with it a bit more I realized there are other conditions that have to be met to make this happen. 1. I set the parameter to prompt 2. Set the parameter default to Non-queried but did not supply a value 3. Unchecked the Multi-value parameter property. It worked like a charm. Thank you. "Bruce L-C [MVP]" wrote: > Read up on URL Access in Books Online. You can collapse the different parts > of the report window like the parameter areas. But keep in mind they can > expand it if they want to. Jump to report will not open in another window, > you were right to use Jump to URL. My guess on why the paramter is not > filling in is because of case sensitivity. Check the parameter in the report > and make sure that you have it exact including case on the URL. > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "TheOriginalStealth" <TheOriginalStealth(a)discussions.microsoft.com> wrote in > message news:54E4FD63-BC5C-41FB-B039-9B2280568EB2(a)microsoft.com... > > Report A jumps to Report B...good > > Report B opens in new window...good > > I have a parameter input box in Report B that is supposed to get populated > > from parameter in Report A...Not working. > > > > 1. How do I make this work > > 2. Is this efficient or is there a better way of doing this? > > 3. I did jump to report but couldn't open it in a new window. Help? > > 4. Also when REPORT B opens, parameters need to be hidden, and > > subscription > > stuff needs to be hidden > > > > ="javascript:void(window.open('http://ReportServer/Reports/Pages/Report.aspx?ItemPath=%2fReports%2fWork_Orders_Past_Due&DEPT_ID= > > 6)','','width=1000,height=600'))" > > > > thanks in advance > > . > |