Groups | Blog | Home
all groups > sql server reporting services > april 2005 >

sql server reporting services : How do we pass parameters when using URL JUMP


Bruce L-C [MVP]
4/15/2005 1:27:39 PM
The below example specifies the directory starting from the root. I have
this because this particular report can reside in a different directory than
the report I am jumping to. If it is in the same directory you can just not
worry about specifying the directory. A couple of others things to note, I
use the globals variable so this will work regardless of where I deploy it.
Also, note that parameter values are case sensitive so you must match it
exactly or you will end up without values in your parameter fields. Also
note that you can add to this URL a command to tell it to hide the parameter
toolbar. Anyway, this should get you started.

=Globals!ReportServerUrl & "?/Inventory/Similar Loads&Manifest=" &
Fields!manifstdocno.Value & "&WasteIDNum=" & Fields!wasteidnum.Value


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services



"James Woo via SQLMonster.com" <forum@nospam.SQLMonster.com> wrote in
message news:ec3e02c313a6498c9a4fbdbc287dfb23@SQLMonster.com...
[quoted text, click to view]

James Woo via SQLMonster.com
4/15/2005 6:10:15 PM
Hi all,

HAve a Horizontal bar Chart I want to drill through, it looks somehtign
like this:

Manager1 ||||||| 70%
Manager2 |||||| 60%
Manager3 |||| 40%

What I want to do is under Data >> Action >> Jump URL instead of Jump to
Report, is pass the manager name to a details-report that is deployed under
my ReportServer.

I have no problems when I user Jump to Report, where parameters can be
defined, but how to we pass parametes from one report to another using URL
Jump to?

Thank you kindly.
James.

--
James Woo via SQLMonster.com
4/15/2005 9:28:49 PM
Thank you Bruce, it worked perfectly.

Where can I find more reading materials on the subject. BOL maybe? or do
you recommend a another resource?

Thanks Again
James Woo

--
AddThis Social Bookmark Button