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.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Jump to URL Option to pass parameter

Author  Topic 

rupalirane07
Starting Member

2 Posts

Posted - 2007-09-09 : 23:48:24
Hi,

I tried to pass the parameter from one report to another using JavaScript function and it works finely.

="javascript:void(window.open('http://hpsi-dev/Reports/Pages/Report.aspx?ItemPath=%2fNextGen+Reports%2fMAUA%2fSales+Order+Detail&rs:Command=Render&SalesOrderNumber="+Fields!SalesOrderNumber.Value+"'))"

i also saw the result in browser url as follows:

http://hpsi-dev/Reports/Pages/Report.aspx?ItemPath=/NextGen+Reports/MAUA/Sales+Order+Detail&rs:Command=Render&SalesOrderNumber=SO43667

but my another report ie. sales order detail does not get this parameter OrderNumber=SO43667 it only opens the blank report.

so is there any function to get the parameter value from browser url.
In asp.net there is function request.querystring
but in Reporting Services 2005 is there any function to get the value from browserurl??????????

pls its urgent.........any help....i can pass the parameter and it shows me the value in browser url but now how to get that value from url...........pls help me
   

- Advertisement -