all groups > sql server reporting services > june 2005 >
You're in the

sql server reporting services

group:

Selective Jump to Report?


Selective Jump to Report? Chris Kennedy
6/30/2005 2:09:05 PM
sql server reporting services:
I would like to be able to disable a Jump to Report link when the value of a
particular field or parameter is a certain value. For example if parameter x
= 1, enable the jump link, but if x = 2, do not allow the jump.

Does anybody know how to do this?

Chris Kennedy
RE: Selective Jump to Report? Harolds
6/30/2005 4:37:03 PM
I haven't done this, but give it a try:

=iif( Parameter!Name.Value = 1,"","ActiveAccounts_04")

[quoted text, click to view]
RE: Selective Jump to Report? Chris Kennedy
7/1/2005 10:51:04 AM
I appreciate the reply, but this doesn't seem to work. I am sending
parameters to the report I am jumping to and when I try to send to a no-name
report it is telling me that the target report doesn't have that parameter.

[quoted text, click to view]
RE: Selective Jump to Report? David Bienstock
7/1/2005 11:10:02 AM
Try the URL section of the jump and then you can use variables...
--
"Everyone knows something you don't know"


[quoted text, click to view]
Re: Selective Jump to Report? Bruce L-C [MVP]
7/1/2005 1:12:56 PM
Put an expression in jump to URL instead. Here is an example of what to put
in:
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



[quoted text, click to view]

Re: Selective Jump to Report? Chris Kennedy
7/5/2005 7:23:03 AM
Thanks for the suggestion. However, I'm still having problems. When I try
your method I get the following error.

The value provided for the report parameter 'Page' is not valid for its
type. (rsReportParameterTypeMismatch)

My parameter is integer and so is the field value I'm sending to it, so I
don't understand why I'm getting this error.

[quoted text, click to view]
Re: Selective Jump to Report? David Bienstock
7/5/2005 7:41:02 AM
What is the expression you are using?
--
"Everyone knows something you don't know"


[quoted text, click to view]
Re: Selective Jump to Report? Bruce L-C [MVP]
7/5/2005 9:46:09 AM
Go into your report. Then menu->Report->Report Parameters. Your parameters
are listed. Click on each one in turn and see what data type they are.

Also, remember when specifying a parameter in command line that they are
case sensitive. If you don't match the case then the value goes in the bit
bucket. If your toolbar is not hidden then you will see that the particular
parameter is not filled in. My suggestion is to always first show the
toolbar and then once working you can hide it.

One last thing, does the report work from Report Manager? Does it work from
the IDE?


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Re: Selective Jump to Report? Chris Kennedy
7/5/2005 12:22:01 PM
I found the problem. I left a "&" out of the string.

Thanks everybody for your help.

Chris

[quoted text, click to view]
AddThis Social Bookmark Button