Jump to Report Issue

I have a "Jump to Report" issue. I have created a report that runs itself
with new parameters when a cell is clicked on. It works great except that
when it is run on the web, the "Jump to Report" has no access to the
parameters. I need to be able to have the parameters visible so the users
can change out their values at will.
I can not find any settings to turn on or off the parameters in the Jump-to
screens.You have to use Jump to URL. Here is an example of an expression that I use
for this. Note the global variable that puts in the server name of where the
report is running from.
=Globals!ReportServerUrl & "?/Inventory/Similar Loads&Manifest=" &
First(Fields!manifstdocno.Value, "LoadID") &"&WasteIDNum=" &
First(Fields!wasteidnum.Value, "LoadID")
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mlapoint" <mlapoint@.discussions.microsoft.com> wrote in message
news:F9EDC25A-F1E3-48A5-9359-D6C4DEF27D4F@.microsoft.com...
> I have a "Jump to Report" issue. I have created a report that runs itself
> with new parameters when a cell is clicked on. It works great except that
> when it is run on the web, the "Jump to Report" has no access to the
> parameters. I need to be able to have the parameters visible so the users
> can change out their values at will.
> I can not find any settings to turn on or off the parameters in the
Jump-to
> screens.

Jump to report and parameters

I have a table where I want to jump to a different report based on the value
in the table cell. The report that I am jumping to has a parameter, and the
parameter value that I need to pass is based on the table cell's value. I
know how to set this up in the report but can't figure out how filter the
dataset that has my parameter values, and I can't filter the dataset using
ReportItems.
If I were to write some pseudocode using SQL it would look something like
this:
PopupReport(Select Param From ParamTable Where ParamKey = Fields!MyTextBox.Value)
Thanks...
Regards,
SteveIf the report you are jumping to has parameters then I am confused on the
issue. When setting up the jump to report you set the parameters of the
report you are jumping to, in this case to the field. That being the case,
what is the problem? The report you are jumping to must be able to accept
the parameter and return the correct data.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Steve" <MyNoSpam@.NoSpam.org> wrote in message
news:00B417ED-8954-4CAC-A07B-48FD361A3575@.microsoft.com...
>I have a table where I want to jump to a different report based on the
>value
> in the table cell. The report that I am jumping to has a parameter, and
> the
> parameter value that I need to pass is based on the table cell's value. I
> know how to set this up in the report but can't figure out how filter the
> dataset that has my parameter values, and I can't filter the dataset using
> ReportItems.
> If I were to write some pseudocode using SQL it would look something like
> this:
> PopupReport(Select Param From ParamTable Where ParamKey => Fields!MyTextBox.Value)
> Thanks...
> Regards,
> Steve|||Hi Bruce,
The problem I have is that the parameter value that I need to pass is in a
SQL table and I need to select the correct parameter based on the cell I am
clicking on.
For instance, the textbox value I am clicking on contains a sales region,
e.g. Central, Northeast, etc, and I want to pass a list of the salereps for
that region into another report. The list of salesreps for that region is
contained in a separate sql table and the sql to find the appropriate list of
salesreps would be something like "Select RepList From Configs Where Region ='Central'", except that the region varies with the row I am clicking on in
the Reporting Services table.
I can make this work if I do something like this for the parameter
expression in the report:
iif(Fields!Region.Value="Central","1,2,3",iif(Fields!Region.Value="Northeast","4,5,6",....))
, but it's kind of ugly and hardcoded...
Hope this is clearer and thanks for your response.
Regards,
Steve
"Bruce L-C [MVP]" wrote:
> If the report you are jumping to has parameters then I am confused on the
> issue. When setting up the jump to report you set the parameters of the
> report you are jumping to, in this case to the field. That being the case,
> what is the problem? The report you are jumping to must be able to accept
> the parameter and return the correct data.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Steve" <MyNoSpam@.NoSpam.org> wrote in message
> news:00B417ED-8954-4CAC-A07B-48FD361A3575@.microsoft.com...
> >I have a table where I want to jump to a different report based on the
> >value
> > in the table cell. The report that I am jumping to has a parameter, and
> > the
> > parameter value that I need to pass is based on the table cell's value. I
> > know how to set this up in the report but can't figure out how filter the
> > dataset that has my parameter values, and I can't filter the dataset using
> > ReportItems.
> >
> > If I were to write some pseudocode using SQL it would look something like
> > this:
> >
> > PopupReport(Select Param From ParamTable Where ParamKey => > Fields!MyTextBox.Value)
> >
> > Thanks...
> >
> > Regards,
> > Steve
>
>

Jump to "No" Report

Hi all,
I'm designing a report that requires a table cell to be able to jump to
another report. This cell needs to be conditional so that if a numeric
value is present, it blocks the ability to jump to another report (and takes
away the link mouse cursor), and if a non numeric value is present (in this
case, a null) it allows jumping to another report.
I can work around by simply having another report page with an error
message, but i'd rather take away the option of making an illegal jump (ie.
the value is numeric) from the end user for ease of use.
eg. Expression in Advanced Properties -> Navigation -> Jump to Report
=IIF(ISNUMERIC(Fields!BaseData.Value), 'No Jump', MyReportName)
Is anyone aware of an phrase/expression i can substitute in for 'No Jump' to
allow this functionality?
Thanks in advance.
JonTry this:
=IIF(ISNUMERIC(Fields!BaseData.Value), Nothing, MyReportName)
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jonathan Martin" <jonathan.martin@.pcservicecall.co.uk> wrote in message
news:uKcYleHNFHA.3928@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> I'm designing a report that requires a table cell to be able to jump to
> another report. This cell needs to be conditional so that if a numeric
> value is present, it blocks the ability to jump to another report (and
> takes away the link mouse cursor), and if a non numeric value is present
> (in this case, a null) it allows jumping to another report.
> I can work around by simply having another report page with an error
> message, but i'd rather take away the option of making an illegal jump
> (ie. the value is numeric) from the end user for ease of use.
> eg. Expression in Advanced Properties -> Navigation -> Jump to Report
> =IIF(ISNUMERIC(Fields!BaseData.Value), 'No Jump', MyReportName)
> Is anyone aware of an phrase/expression i can substitute in for 'No Jump'
> to allow this functionality?
> Thanks in advance.
>
> Jon
>|||Thanks for getting back to me.
That worked fine with one slight alteration. The final syntax was as
follows. Note the speech marks around the valid jump report's name.
=IIF(ISNUMERIC(Fields!BaseData.Value), Nothing, "MyReportName")
Thanks!
Jon
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:uv3uiHJNFHA.2132@.TK2MSFTNGP14.phx.gbl...
> Try this:
> =IIF(ISNUMERIC(Fields!BaseData.Value), Nothing, MyReportName)
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Jonathan Martin" <jonathan.martin@.pcservicecall.co.uk> wrote in message
> news:uKcYleHNFHA.3928@.TK2MSFTNGP09.phx.gbl...
>> Hi all,
>> I'm designing a report that requires a table cell to be able to jump to
>> another report. This cell needs to be conditional so that if a numeric
>> value is present, it blocks the ability to jump to another report (and
>> takes away the link mouse cursor), and if a non numeric value is present
>> (in this case, a null) it allows jumping to another report.
>> I can work around by simply having another report page with an error
>> message, but i'd rather take away the option of making an illegal jump
>> (ie. the value is numeric) from the end user for ease of use.
>> eg. Expression in Advanced Properties -> Navigation -> Jump to Report
>> =IIF(ISNUMERIC(Fields!BaseData.Value), 'No Jump', MyReportName)
>> Is anyone aware of an phrase/expression i can substitute in for 'No Jump'
>> to allow this functionality?
>> Thanks in advance.
>>
>> Jon
>>
>