Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Jump to URL paramater not working in ssrs 2005 Expand / Collapse
Author
Message
Posted Tuesday, April 23, 2013 10:57 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 12:14 PM
Points: 14, Visits: 172
Hello,

I am using ssrs 2005 I have a main report and a subreport. When the user click on the dollar amount on the income statement (main report) the subreport will appear (Test Detail Income Statement - Actual Drill Down.rdl), which is fine, but I have a parameter in the subreport call AccountDescription and unfortuantelly I am not getting the data just the report shell. The user can click on the drop down parameter on the subreport, but that is an extra step, which I don't want the user to do. I wanted to pass the parameter to Jump to URL and it is not working. On a particular text box on the main report I have gone into properties-> Navigation->Jump to URL: Below is my code, which I thought will automatically get my data (Supplies) I also want to add another parameter call Year. I have looked into many websites and unable to find my particular problem. If anyone can help I would really appreciate. Thank you in advance.



="void(window.open('http://MAS200/ReportsManager/Pages/Report.aspx?ItemPath=%2fAccounting%2fFinancial+Reports%2fTest+Detail+Income+Statement+-+Actual+Drill+Down&AccountDescription=Supplies','_blank'))"
Post #1445583
Posted Thursday, April 25, 2013 3:25 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 3:17 AM
Points: 321, Visits: 592
Can't you pass the parameter to the sub report?

http://msdn.microsoft.com/en-us/library/ms160348(v=sql.100).aspx


SQL SERVER Central Forum Etiquette
Post #1446736
Posted Tuesday, April 30, 2013 8:06 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 12:14 PM
Points: 14, Visits: 172
Thank you I have done Jump to report instead. No issues.
Post #1448048
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse