Drillthrough Report with Parameters - Jump to URL not working

Hello,
I'm hoping to have a drillthrough report appear in a separate window but am
struggling to get it to work. I'm attempting to use the textbox navigation
property "Jump to URL", placing Javascript in the property field that should
render the child report in a separate window.
I can get this to work if the child report does not have parameters. But
when the child report does have parameters the child report is displayed in
the report manager UI, but all it shows is the parameter textboxes and I
need to enter the parameter data again and click "View Report" to get the
report to render. I would like the report to render in the new window
automatically.
I've seen many variations on how to get the "Jump to URL" to work and have
tried them with no luck, at least when the child report requires parameters.
Thanks in advance for any help that can be provided.
JackDo you have these parameters hidden in your "jump to" report?
"Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
news:eJemu58nIHA.548@.TK2MSFTNGP06.phx.gbl...
> Hello,
> I'm hoping to have a drillthrough report appear in a separate window but
> am struggling to get it to work. I'm attempting to use the textbox
> navigation property "Jump to URL", placing Javascript in the property
> field that should render the child report in a separate window.
> I can get this to work if the child report does not have parameters. But
> when the child report does have parameters the child report is displayed
> in the report manager UI, but all it shows is the parameter textboxes and
> I need to enter the parameter data again and click "View Report" to get
> the report to render. I would like the report to render in the new
> window automatically.
> I've seen many variations on how to get the "Jump to URL" to work and have
> tried them with no luck, at least when the child report requires
> parameters.
> Thanks in advance for any help that can be provided.
> Jack
>|||Thanks Mark. I did not have the hidden property set. Setting the hidden
property on now causes an error to be displayed in the child window
indicating the parameter value wasn't provided. "The 'Param1' parameter
is missing a value"
Here's the java I'm trying to use, which works fine w/o the parameter(Parent
and Child report reside in the same folder).
="javascript:void(window.open('Report.aspx?ItemPath=%2fReportFolder%2fDrillThroughSubReport&Param1="
& Fields!MyParamField.Value & "'))"
Thanks again,
Jack
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:u3wGOL9nIHA.1240@.TK2MSFTNGP02.phx.gbl...
> Do you have these parameters hidden in your "jump to" report?
> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
> news:eJemu58nIHA.548@.TK2MSFTNGP06.phx.gbl...
>> Hello,
>> I'm hoping to have a drillthrough report appear in a separate window but
>> am struggling to get it to work. I'm attempting to use the textbox
>> navigation property "Jump to URL", placing Javascript in the property
>> field that should render the child report in a separate window.
>> I can get this to work if the child report does not have parameters. But
>> when the child report does have parameters the child report is displayed
>> in the report manager UI, but all it shows is the parameter textboxes and
>> I need to enter the parameter data again and click "View Report" to get
>> the report to render. I would like the report to render in the new
>> window automatically.
>> I've seen many variations on how to get the "Jump to URL" to work and
>> have tried them with no luck, at least when the child report requires
>> parameters.
>> Thanks in advance for any help that can be provided.
>> Jack
>|||This is my JS code to run some code on the back-end.
See if helps you to find right syntax:
=("javascript:void(window.open('http://localhost/some.htm?parm1=" &
Fields!gaylordid.Value & "','price',
'status=0,toolbar=0,width=630,height=700,center=yes'))")
"Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
news:e4n7qy9nIHA.4904@.TK2MSFTNGP03.phx.gbl...
> Thanks Mark. I did not have the hidden property set. Setting the
> hidden property on now causes an error to be displayed in the child window
> indicating the parameter value wasn't provided. "The 'Param1' parameter
> is missing a value"
> Here's the java I'm trying to use, which works fine w/o the
> parameter(Parent and Child report reside in the same folder).
> ="javascript:void(window.open('Report.aspx?ItemPath=%2fReportFolder%2fDrillThroughSubReport&Param1="
> & Fields!MyParamField.Value & "'))"
> Thanks again,
> Jack
>
> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
> news:u3wGOL9nIHA.1240@.TK2MSFTNGP02.phx.gbl...
>> Do you have these parameters hidden in your "jump to" report?
>> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
>> news:eJemu58nIHA.548@.TK2MSFTNGP06.phx.gbl...
>> Hello,
>> I'm hoping to have a drillthrough report appear in a separate window but
>> am struggling to get it to work. I'm attempting to use the textbox
>> navigation property "Jump to URL", placing Javascript in the property
>> field that should render the child report in a separate window.
>> I can get this to work if the child report does not have parameters.
>> But when the child report does have parameters the child report is
>> displayed in the report manager UI, but all it shows is the parameter
>> textboxes and I need to enter the parameter data again and click "View
>> Report" to get the report to render. I would like the report to render
>> in the new window automatically.
>> I've seen many variations on how to get the "Jump to URL" to work and
>> have tried them with no luck, at least when the child report requires
>> parameters.
>> Thanks in advance for any help that can be provided.
>> Jack
>>
>|||Thanks Mark. I've tried a number of different approaches with the JS
syntax and have gotten them all to work w/o parameters so I think my syntax
up to the point of calling the page/report is OK, even though our two
versions are quite different.(but JS is new to me) Also, it appears our
code to include the parameters is set up the same for the most part so I'm
thinking that may be OK too.
I've tried so many different versions of JS syntax with the same results I'm
wondering if something else isn't in play here. I'm trying to publish and
run these reports on an RS "Report Manager" website, where it appears you
may be referencing an HTML web page. Did you ever go the Report Manager
route with success so I could be certain what I'm trying to do(and what
you've done) is "doable" in that environment?(RS is new to me too)
Thanks again for your time, it's appreciated.
Jack
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:%23W3nFG%23nIHA.420@.TK2MSFTNGP02.phx.gbl...
> This is my JS code to run some code on the back-end.
> See if helps you to find right syntax:
> =("javascript:void(window.open('http://localhost/some.htm?parm1=" &
> Fields!gaylordid.Value & "','price',
> 'status=0,toolbar=0,width=630,height=700,center=yes'))")
> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
> news:e4n7qy9nIHA.4904@.TK2MSFTNGP03.phx.gbl...
>> Thanks Mark. I did not have the hidden property set. Setting the
>> hidden property on now causes an error to be displayed in the child
>> window indicating the parameter value wasn't provided. "The 'Param1'
>> parameter is missing a value"
>> Here's the java I'm trying to use, which works fine w/o the
>> parameter(Parent and Child report reside in the same folder).
>> ="javascript:void(window.open('Report.aspx?ItemPath=%2fReportFolder%2fDrillThroughSubReport&Param1="
>> & Fields!MyParamField.Value & "'))"
>> Thanks again,
>> Jack
>>
>> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
>> news:u3wGOL9nIHA.1240@.TK2MSFTNGP02.phx.gbl...
>> Do you have these parameters hidden in your "jump to" report?
>> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
>> news:eJemu58nIHA.548@.TK2MSFTNGP06.phx.gbl...
>> Hello,
>> I'm hoping to have a drillthrough report appear in a separate window
>> but am struggling to get it to work. I'm attempting to use the
>> textbox navigation property "Jump to URL", placing Javascript in the
>> property field that should render the child report in a separate
>> window.
>> I can get this to work if the child report does not have parameters.
>> But when the child report does have parameters the child report is
>> displayed in the report manager UI, but all it shows is the parameter
>> textboxes and I need to enter the parameter data again and click "View
>> Report" to get the report to render. I would like the report to
>> render in the new window automatically.
>> I've seen many variations on how to get the "Jump to URL" to work and
>> have tried them with no luck, at least when the child report requires
>> parameters.
>> Thanks in advance for any help that can be provided.
>> Jack
>>
>>
>|||I was able to get my problem resolved - thanks Mark for taking some time to
help.
The change that appears to resolve my problem was adding the "reportserver"
literal to the URL. I could reference the child report page in a variety of
different methods of JS syntax but the parameter processing wouldn't work
until I included the reportserver folder in the URL string I placed in the
Jump to URL property. Getting to my child report page by any other method
appeared to cause the parameter passing to fail.
Working JS string:
=("javascript:void(window.open('http://servername/Reportserver/Pages/Report.aspx?%2fMyReports%2fMyDrillThroughReport&Parm1="
& Fields!MyParm.Value
&"','Detail','resizeable=1,toolbar=0,status=0,menu=0,top=20,left=20,width=740,height=930'))"
)
Thanks again,
Jack
"Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
news:uVcqiQ$nIHA.3376@.TK2MSFTNGP05.phx.gbl...
> Thanks Mark. I've tried a number of different approaches with the JS
> syntax and have gotten them all to work w/o parameters so I think my
> syntax up to the point of calling the page/report is OK, even though our
> two versions are quite different.(but JS is new to me) Also, it appears
> our code to include the parameters is set up the same for the most part so
> I'm thinking that may be OK too.
>
> I've tried so many different versions of JS syntax with the same results
> I'm wondering if something else isn't in play here. I'm trying to
> publish and run these reports on an RS "Report Manager" website, where it
> appears you may be referencing an HTML web page. Did you ever go the
> Report Manager route with success so I could be certain what I'm trying to
> do(and what you've done) is "doable" in that environment?(RS is new to me
> too)
>
> Thanks again for your time, it's appreciated.
>
> Jack
>
> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
> news:%23W3nFG%23nIHA.420@.TK2MSFTNGP02.phx.gbl...
>> This is my JS code to run some code on the back-end.
>> See if helps you to find right syntax:
>> =("javascript:void(window.open('http://localhost/some.htm?parm1=" &
>> Fields!gaylordid.Value & "','price',
>> 'status=0,toolbar=0,width=630,height=700,center=yes'))")
>> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
>> news:e4n7qy9nIHA.4904@.TK2MSFTNGP03.phx.gbl...
>> Thanks Mark. I did not have the hidden property set. Setting the
>> hidden property on now causes an error to be displayed in the child
>> window indicating the parameter value wasn't provided. "The 'Param1'
>> parameter is missing a value"
>> Here's the java I'm trying to use, which works fine w/o the
>> parameter(Parent and Child report reside in the same folder).
>> ="javascript:void(window.open('Report.aspx?ItemPath=%2fReportFolder%2fDrillThroughSubReport&Param1="
>> & Fields!MyParamField.Value & "'))"
>> Thanks again,
>> Jack
>>
>> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
>> news:u3wGOL9nIHA.1240@.TK2MSFTNGP02.phx.gbl...
>> Do you have these parameters hidden in your "jump to" report?
>> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
>> news:eJemu58nIHA.548@.TK2MSFTNGP06.phx.gbl...
>> Hello,
>> I'm hoping to have a drillthrough report appear in a separate window
>> but am struggling to get it to work. I'm attempting to use the
>> textbox navigation property "Jump to URL", placing Javascript in the
>> property field that should render the child report in a separate
>> window.
>> I can get this to work if the child report does not have parameters.
>> But when the child report does have parameters the child report is
>> displayed in the report manager UI, but all it shows is the parameter
>> textboxes and I need to enter the parameter data again and click "View
>> Report" to get the report to render. I would like the report to
>> render in the new window automatically.
>> I've seen many variations on how to get the "Jump to URL" to work and
>> have tried them with no luck, at least when the child report requires
>> parameters.
>> Thanks in advance for any help that can be provided.
>> Jack
>>
>>
>>
>