Wednesday, March 7, 2012

Parameters are getting hidden while using Jump to report

Hi,
I am trying to have drill down from a report to another report. I am using
"Jump to URL" drill down to another report. Everything works fine except that
the parameters get hidden int he second report. Is there anyway i can have
the parameters visible while using the jump to report?
Thanks
PradyThere are a load of parameters you can add to the URL to control the
appearance of the report. Try tacking "&rc:Parameters=true" to the URL
(without the quotes!). Look for "URL Access" in Books Online for all
the options available.
Just a bit of a pedantic correction, but this sort of drilling is
generally termed "Drill Through", when you expand data to show more
detail, this is termed "Drill down". Semantics lesson over with now! :-)
Cheers
Chris
prady wrote:
> Hi,
> I am trying to have drill down from a report to another report. I am
> using "Jump to URL" drill down to another report. Everything works
> fine except that the parameters get hidden int he second report. Is
> there anyway i can have the parameters visible while using the jump
> to report? Thanks
> Prady|||chris
where exactly do i have to add the 'rc:paramaters=true' bit?
can i still use option 'jump to report' then or do i have to chose jump to
url with the url of my jump-to report with the rc:... bit?
if i take the jump to report possibility, configure my pass parameter
values, my rdl looks like this
<Drillthrough>
<Parameters>
<Parameter Name="startdate">
<value>= Parameters!startdate.Value</Value>
</Parameter>
<Parameter Name="enddate">
<Value>= Parameters!enddate.Value</Value>
</Parameter>
</Parameters>
<ReportName>Availability SLA</ReportName>
</Drillthrough>
can i specify here somewhere to show the parametertoolbar?
thx
stefan
"Chris" wrote:
> There are a load of parameters you can add to the URL to control the
> appearance of the report. Try tacking "&rc:Parameters=true" to the URL
> (without the quotes!). Look for "URL Access" in Books Online for all
> the options available.
> Just a bit of a pedantic correction, but this sort of drilling is
> generally termed "Drill Through", when you expand data to show more
> detail, this is termed "Drill down". Semantics lesson over with now! :-)
> Cheers
> Chris
>
> prady wrote:
> > Hi,
> > I am trying to have drill down from a report to another report. I am
> > using "Jump to URL" drill down to another report. Everything works
> > fine except that the parameters get hidden int he second report. Is
> > there anyway i can have the parameters visible while using the jump
> > to report? Thanks
> > Prady
>
> --
>|||Stefan,
You've probably sussed this by now, if you are using the url access
parameters, then yes you do need to use "jump to url" not "jump to
report". The url should point to the report server NOT the report
manager. The difference is http://myServer/ReportServer is the
"server", http://myServer/Reports is the "manager".
Search for "url access" in BOL for the order you put things in.
Chris
Stefan wrote:
> chris
> where exactly do i have to add the 'rc:paramaters=true' bit?
> can i still use option 'jump to report' then or do i have to chose
> jump to url with the url of my jump-to report with the rc:... bit?
> if i take the jump to report possibility, configure my pass parameter
> values, my rdl looks like this
> <Drillthrough>
> <Parameters>
> <Parameter Name="startdate">
> <value>= Parameters!startdate.Value</Value>
> </Parameter>
> <Parameter Name="enddate">
> <Value>= Parameters!enddate.Value</Value>
> </Parameter>
> </Parameters>
> <ReportName>Availability SLA</ReportName>
> </Drillthrough>
> can i specify here somewhere to show the parametertoolbar?
> thx
> stefan
> "Chris" wrote:
> > There are a load of parameters you can add to the URL to control the
> > appearance of the report. Try tacking "&rc:Parameters=true" to the
> > URL (without the quotes!). Look for "URL Access" in Books Online
> > for all the options available.
> >
> > Just a bit of a pedantic correction, but this sort of drilling is
> > generally termed "Drill Through", when you expand data to show more
> > detail, this is termed "Drill down". Semantics lesson over with
> > now! :-)
> >
> > Cheers
> > Chris
> >
> >
> > prady wrote:
> >
> > > Hi,
> > > I am trying to have drill down from a report to another report. I
> > > am using "Jump to URL" drill down to another report. Everything
> > > works fine except that the parameters get hidden int he second
> > > report. Is there anyway i can have the parameters visible while
> > > using the jump to report? Thanks
> > > Prady
> >
> >
> >
> > --
> >
> >

No comments:

Post a Comment