How to Code Conditional "Jump to Report"

I have a system summary report where I want to allow them to drill-thru to
the detail system report only if the system's percent available is less than
100%. I tried to use the Fx on the "jump to report" to enter an IIF
statement something like
=IIF(ReportItems!Percent_Avail.Value < 100, "Detail_Report_Name", "") and
various other things but it didnt work. How can I do this ? I want to
essentially turn OFF the action if the percent is 100 and allow them to
drill-thru to the detail if it is less than 100 percent. The FX is there
next to where you select the report to jump to so I should be able to code an
expression from what I read. Thanks!!I have done something similar with Jump to URL:
= iif( mid(Fields!db_uniqueloadid.Value,1,2)="CP" ,Globals!ReportServerUrl &
"?/Inventory/Composite+Info&CompositeID=" & Fields!db_uniqueloadid.Value
,Globals!ReportServerUrl & "?/Inventory/Load+ID&UniqueLoadID=" &
Fields!db_uniqueloadid.Value)
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
news:EC316C43-E68F-4523-BC3B-A131BF4F8AED@.microsoft.com...
>I have a system summary report where I want to allow them to drill-thru to
> the detail system report only if the system's percent available is less
> than
> 100%. I tried to use the Fx on the "jump to report" to enter an IIF
> statement something like
> =IIF(ReportItems!Percent_Avail.Value < 100, "Detail_Report_Name", "") and
> various other things but it didnt work. How can I do this ? I want to
> essentially turn OFF the action if the percent is 100 and allow them to
> drill-thru to the detail if it is less than 100 percent. The FX is there
> next to where you select the report to jump to so I should be able to code
> an
> expression from what I read. Thanks!!|||I cant use "jump to url" ... is there a way to do what I am asking? If so ..
I am not sure how to code the empty string for the report. It gives me an
error about the report cant be loaded or something
"Bruce L-C [MVP]" wrote:
> I have done something similar with Jump to URL:
> = iif( mid(Fields!db_uniqueloadid.Value,1,2)="CP" ,Globals!ReportServerUrl &
> "?/Inventory/Composite+Info&CompositeID=" & Fields!db_uniqueloadid.Value
> ,Globals!ReportServerUrl & "?/Inventory/Load+ID&UniqueLoadID=" &
> Fields!db_uniqueloadid.Value)
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
> news:EC316C43-E68F-4523-BC3B-A131BF4F8AED@.microsoft.com...
> >I have a system summary report where I want to allow them to drill-thru to
> > the detail system report only if the system's percent available is less
> > than
> > 100%. I tried to use the Fx on the "jump to report" to enter an IIF
> > statement something like
> > =IIF(ReportItems!Percent_Avail.Value < 100, "Detail_Report_Name", "") and
> > various other things but it didnt work. How can I do this ? I want to
> > essentially turn OFF the action if the percent is 100 and allow them to
> > drill-thru to the detail if it is less than 100 percent. The FX is there
> > next to where you select the report to jump to so I should be able to code
> > an
> > expression from what I read. Thanks!!
>
>|||Why can't you use jump to url? I don't understand, anyplace you can use jump
to report you can use jump to URL. Jump to report is a bit handier but both
will work.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
news:BA135695-39B6-48C6-89FF-0F9965E69006@.microsoft.com...
>I cant use "jump to url" ... is there a way to do what I am asking? If so
>..
> I am not sure how to code the empty string for the report. It gives me an
> error about the report cant be loaded or something
> "Bruce L-C [MVP]" wrote:
>> I have done something similar with Jump to URL:
>> = iif( mid(Fields!db_uniqueloadid.Value,1,2)="CP"
>> ,Globals!ReportServerUrl &
>> "?/Inventory/Composite+Info&CompositeID=" & Fields!db_uniqueloadid.Value
>> ,Globals!ReportServerUrl & "?/Inventory/Load+ID&UniqueLoadID=" &
>> Fields!db_uniqueloadid.Value)
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
>> news:EC316C43-E68F-4523-BC3B-A131BF4F8AED@.microsoft.com...
>> >I have a system summary report where I want to allow them to drill-thru
>> >to
>> > the detail system report only if the system's percent available is less
>> > than
>> > 100%. I tried to use the Fx on the "jump to report" to enter an IIF
>> > statement something like
>> > =IIF(ReportItems!Percent_Avail.Value < 100, "Detail_Report_Name", "")
>> > and
>> > various other things but it didnt work. How can I do this ? I want
>> > to
>> > essentially turn OFF the action if the percent is 100 and allow them to
>> > drill-thru to the detail if it is less than 100 percent. The FX is
>> > there
>> > next to where you select the report to jump to so I should be able to
>> > code
>> > an
>> > expression from what I read. Thanks!!
>>|||how would I code that passing parameters? not sure of the syntax. In
addition ... where would the server name come from? We are having issues
with exposing the url to the end users since it contains a parameter that
would allow them to get somewhere they shouldnt (if they knew how ). Someone
from MS is working on that for my company right now. I saw on the portal
that "jump to report" exposes the parameters the same as "jump to url"
probably. So .. that brings me back to syntax ... how do I code the
parameter "values" ... I know the parameter you code in the url as
¶meter_name= <= but how to code the field that goes in there from
the report you are drilling from?
"Bruce L-C [MVP]" wrote:
> Why can't you use jump to url? I don't understand, anyplace you can use jump
> to report you can use jump to URL. Jump to report is a bit handier but both
> will work.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
> news:BA135695-39B6-48C6-89FF-0F9965E69006@.microsoft.com...
> >I cant use "jump to url" ... is there a way to do what I am asking? If so
> >..
> > I am not sure how to code the empty string for the report. It gives me an
> > error about the report cant be loaded or something
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> I have done something similar with Jump to URL:
> >>
> >> = iif( mid(Fields!db_uniqueloadid.Value,1,2)="CP"
> >> ,Globals!ReportServerUrl &
> >> "?/Inventory/Composite+Info&CompositeID=" & Fields!db_uniqueloadid.Value
> >> ,Globals!ReportServerUrl & "?/Inventory/Load+ID&UniqueLoadID=" &
> >> Fields!db_uniqueloadid.Value)
> >>
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
> >> news:EC316C43-E68F-4523-BC3B-A131BF4F8AED@.microsoft.com...
> >> >I have a system summary report where I want to allow them to drill-thru
> >> >to
> >> > the detail system report only if the system's percent available is less
> >> > than
> >> > 100%. I tried to use the Fx on the "jump to report" to enter an IIF
> >> > statement something like
> >> > =IIF(ReportItems!Percent_Avail.Value < 100, "Detail_Report_Name", "")
> >> > and
> >> > various other things but it didnt work. How can I do this ? I want
> >> > to
> >> > essentially turn OFF the action if the percent is 100 and allow them to
> >> > drill-thru to the detail if it is less than 100 percent. The FX is
> >> > there
> >> > next to where you select the report to jump to so I should be able to
> >> > code
> >> > an
> >> > expression from what I read. Thanks!!
> >>
> >>
> >>
>
>|||True, from a security viewpoint there is no difference. You can turn off the
parameter area so they can't change it from Report Manager but if someone
wants to figure out and change the URL that can be done. You have to use web
services if you want to totally hide everything from the user.
As far as how to create this. Look at my example, it covers everything.
Including the use of Globals!ReportServerUrl so no server name is
hardcoded. I suggest trying jump to url without being fancy and then add in
your iif statement.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
news:51B133E4-55DA-4F15-9ABF-BF688E5CBA0F@.microsoft.com...
> how would I code that passing parameters? not sure of the syntax. In
> addition ... where would the server name come from? We are having issues
> with exposing the url to the end users since it contains a parameter that
> would allow them to get somewhere they shouldnt (if they knew how ).
> Someone
> from MS is working on that for my company right now. I saw on the portal
> that "jump to report" exposes the parameters the same as "jump to url"
> probably. So .. that brings me back to syntax ... how do I code the
> parameter "values" ... I know the parameter you code in the url as
> ¶meter_name= <= but how to code the field that goes in there
> from
> the report you are drilling from?
> "Bruce L-C [MVP]" wrote:
>> Why can't you use jump to url? I don't understand, anyplace you can use
>> jump
>> to report you can use jump to URL. Jump to report is a bit handier but
>> both
>> will work.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
>> news:BA135695-39B6-48C6-89FF-0F9965E69006@.microsoft.com...
>> >I cant use "jump to url" ... is there a way to do what I am asking? If
>> >so
>> >..
>> > I am not sure how to code the empty string for the report. It gives me
>> > an
>> > error about the report cant be loaded or something
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> I have done something similar with Jump to URL:
>> >>
>> >> = iif( mid(Fields!db_uniqueloadid.Value,1,2)="CP"
>> >> ,Globals!ReportServerUrl &
>> >> "?/Inventory/Composite+Info&CompositeID=" &
>> >> Fields!db_uniqueloadid.Value
>> >> ,Globals!ReportServerUrl & "?/Inventory/Load+ID&UniqueLoadID=" &
>> >> Fields!db_uniqueloadid.Value)
>> >>
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
>> >> news:EC316C43-E68F-4523-BC3B-A131BF4F8AED@.microsoft.com...
>> >> >I have a system summary report where I want to allow them to
>> >> >drill-thru
>> >> >to
>> >> > the detail system report only if the system's percent available is
>> >> > less
>> >> > than
>> >> > 100%. I tried to use the Fx on the "jump to report" to enter an IIF
>> >> > statement something like
>> >> > =IIF(ReportItems!Percent_Avail.Value < 100, "Detail_Report_Name",
>> >> > "")
>> >> > and
>> >> > various other things but it didnt work. How can I do this ? I
>> >> > want
>> >> > to
>> >> > essentially turn OFF the action if the percent is 100 and allow them
>> >> > to
>> >> > drill-thru to the detail if it is less than 100 percent. The FX is
>> >> > there
>> >> > next to where you select the report to jump to so I should be able
>> >> > to
>> >> > code
>> >> > an
>> >> > expression from what I read. Thanks!!
>> >>
>> >>
>> >>
>>|||I have the same problem, Did you ever figure out how to shut off the action?
thanks.
"MJ Taft" wrote:
> I have a system summary report where I want to allow them to drill-thru to
> the detail system report only if the system's percent available is less than
> 100%. I tried to use the Fx on the "jump to report" to enter an IIF
> statement something like
> =IIF(ReportItems!Percent_Avail.Value < 100, "Detail_Report_Name", "") and
> various other things but it didnt work. How can I do this ? I want to
> essentially turn OFF the action if the percent is 100 and allow them to
> drill-thru to the detail if it is less than 100 percent. The FX is there
> next to where you select the report to jump to so I should be able to code an
> expression from what I read. Thanks!!|||I knew the minute I sent this that I'd figure it out.
I had to use the keywork NOTHING.
= IIF(Fields!Failed_rule_Rule_Cd.Value = "",Nothing,"Page.aspx")
"Paula" wrote:
> I have the same problem, Did you ever figure out how to shut off the action?
> thanks.
> "MJ Taft" wrote:
> > I have a system summary report where I want to allow them to drill-thru to
> > the detail system report only if the system's percent available is less than
> > 100%. I tried to use the Fx on the "jump to report" to enter an IIF
> > statement something like
> > =IIF(ReportItems!Percent_Avail.Value < 100, "Detail_Report_Name", "") and
> > various other things but it didnt work. How can I do this ? I want to
> > essentially turn OFF the action if the percent is 100 and allow them to
> > drill-thru to the detail if it is less than 100 percent. The FX is there
> > next to where you select the report to jump to so I should be able to code an
> > expression from what I read. Thanks!!