Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
donalejandro61
Starting Member
4 Posts |
Posted - 2013-04-23 : 13:07:37
|
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.="javascript:void(window.open('http://MAS200/ReportsManager/Pages/Report.aspx?ItemPath=%2fAccounting%2fFinancial+Reports%2fTest+Detail+Income+Statement+-+Actual+Drill+Down&AccountDescription=Supplies','_blank'))" |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-23 : 13:30:51
|
is the parameter name AccountDescription in subreport? also do you've supplies as a value among list of values for the parameter (the supplies should be present as a value in dataset used to populate AccountDescription parameter and not only in prompt.)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|