all groups > sql server reporting services > june 2005 >
You're in the sql server reporting services group:
Selective Jump to Report?
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
I haven't done this, but give it a try: =iif( Parameter!Name.Value = 1,"","ActiveAccounts_04") [quoted text, click to view] "Chris Kennedy" wrote: > 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
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] "Harolds" wrote: > I haven't done this, but give it a try: > > =iif( Parameter!Name.Value = 1,"","ActiveAccounts_04") > > "Chris Kennedy" wrote: > > > 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
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] "Chris Kennedy" wrote: > 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. > > "Harolds" wrote: > > > I haven't done this, but give it a try: > > > > =iif( Parameter!Name.Value = 1,"","ActiveAccounts_04") > > > > "Chris Kennedy" wrote: > > > > > 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
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] "Chris Kennedy" <ChrisKennedy@discussions.microsoft.com> wrote in message news:8E38851F-E5E5-44F1-B79D-4DB9FB1F345C@microsoft.com... >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. > > "Harolds" wrote: > >> I haven't done this, but give it a try: >> >> =iif( Parameter!Name.Value = 1,"","ActiveAccounts_04") >> >> "Chris Kennedy" wrote: >> >> > 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 >> >
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] "Bruce L-C [MVP]" wrote: > 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 > > > > "Chris Kennedy" <ChrisKennedy@discussions.microsoft.com> wrote in message > news:8E38851F-E5E5-44F1-B79D-4DB9FB1F345C@microsoft.com... > >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. > > > > "Harolds" wrote: > > > >> I haven't done this, but give it a try: > >> > >> =iif( Parameter!Name.Value = 1,"","ActiveAccounts_04") > >> > >> "Chris Kennedy" wrote: > >> > >> > 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 > >> > > >
What is the expression you are using? -- "Everyone knows something you don't know" [quoted text, click to view] "Chris Kennedy" wrote: > 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. > > "Bruce L-C [MVP]" wrote: > > > 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 > > > > > > > > "Chris Kennedy" <ChrisKennedy@discussions.microsoft.com> wrote in message > > news:8E38851F-E5E5-44F1-B79D-4DB9FB1F345C@microsoft.com... > > >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. > > > > > > "Harolds" wrote: > > > > > >> I haven't done this, but give it a try: > > >> > > >> =iif( Parameter!Name.Value = 1,"","ActiveAccounts_04") > > >> > > >> "Chris Kennedy" wrote: > > >> > > >> > 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 > > >> > > > > >
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] "Chris Kennedy" <ChrisKennedy@discussions.microsoft.com> wrote in message news:FE1BE5FC-B917-4509-A97A-CB4222A9A749@microsoft.com... > 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. > > "Bruce L-C [MVP]" wrote: > >> 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 >> >> >> >> "Chris Kennedy" <ChrisKennedy@discussions.microsoft.com> wrote in message >> news:8E38851F-E5E5-44F1-B79D-4DB9FB1F345C@microsoft.com... >> >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. >> > >> > "Harolds" wrote: >> > >> >> I haven't done this, but give it a try: >> >> >> >> =iif( Parameter!Name.Value = 1,"","ActiveAccounts_04") >> >> >> >> "Chris Kennedy" wrote: >> >> >> >> > 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 >> >> > >> >> >>
I found the problem. I left a "&" out of the string. Thanks everybody for your help. Chris [quoted text, click to view] "David Bienstock" wrote: > What is the expression you are using? > -- > "Everyone knows something you don't know" > > > "Chris Kennedy" wrote: > > > 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. > > > > "Bruce L-C [MVP]" wrote: > > > > > 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 > > > > > > > > > > > > "Chris Kennedy" <ChrisKennedy@discussions.microsoft.com> wrote in message > > > news:8E38851F-E5E5-44F1-B79D-4DB9FB1F345C@microsoft.com... > > > >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. > > > > > > > > "Harolds" wrote: > > > > > > > >> I haven't done this, but give it a try: > > > >> > > > >> =iif( Parameter!Name.Value = 1,"","ActiveAccounts_04") > > > >> > > > >> "Chris Kennedy" wrote: > > > >> > > > >> > 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 > > > >> > > > > > > >
Don't see what you're looking for? Try a search.
|
|
|