parameters not showing up in report manager

Hi,
My MAIN report jumps to REPORT1 using the "jump to report:" hyperlink
action of a textbox. REPORT1 has one parameter.
Every thing works fine except I would like to be able to change REPORT1
parameter after I execute it, but it does not display when in Report
Manager.
ie. I jump from MAIN report to REPORT1 passing parameter1="XXX".
REPORT1 displays fine. While in REPORT1, I would like to change
parameter1="ZZZ".
I am unable to do this in the Report Manager because it will not show up in
the parameter header of Report Manager when I jump from MAIN to REPORT1.
It will show up if I execute REPORT1 by itself.
How can I get REPORT1 parameter1 to display after I jump to it from the MAIN
report using the report manager?
I have checked "prompt user" of REPORT1 setup in Report Manager.
Thanks,
___________________________
Daniel J. Zaccarine
Hanford Bay Associates, Ltd.
___________________________You need to use jump to URL instead. (at least that is the only way I found
to do it). Note that you can use some of the global variables with the
expression builder to create this on the fly (so it changes with wherever it
is deployed.
http://servername/Reports/Pages/Report.aspx?ServerUrl=http://servername/ReportServer%3f/directoryname%252fReportName&Parameter1=blahblah&rc:Parameters=True
Bruce L-C
"Dan" <dan_zaccarine@.hanfordbay.com> wrote in message
news:uMzOo%23obEHA.2476@.TK2MSFTNGP09.phx.gbl...
> Hi,
> My MAIN report jumps to REPORT1 using the "jump to report:" hyperlink
> action of a textbox. REPORT1 has one parameter.
> Every thing works fine except I would like to be able to change REPORT1
> parameter after I execute it, but it does not display when in Report
> Manager.
> ie. I jump from MAIN report to REPORT1 passing parameter1="XXX".
> REPORT1 displays fine. While in REPORT1, I would like to change
> parameter1="ZZZ".
> I am unable to do this in the Report Manager because it will not show up
in
> the parameter header of Report Manager when I jump from MAIN to REPORT1.
> It will show up if I execute REPORT1 by itself.
> How can I get REPORT1 parameter1 to display after I jump to it from the
MAIN
> report using the report manager?
> I have checked "prompt user" of REPORT1 setup in Report Manager.
> Thanks,
> ___________________________
> Daniel J. Zaccarine
> Hanford Bay Associates, Ltd.
> ___________________________
>

Parameters in Jump Reports

Good morning all:
I am having an issue when jumping from one report to the next. The issue is
that the users want the reports to run without having to enter any
additional information but may want to change some of the parameters after
the report has run. I have accomplished the first part of the requirement
but the parameters are not showing themselves for the second part of the
requirement.
When I run the reports with out jumping to it the parameters are exposed and
the user can select them but when it is called from another report they
don't show at all.
Is there some setting somewhere that will force the parameters to show even
if they don't need to be modified?
Thanks,
AlNever mind mystery solved. It turns out that the parameter area of the
report is collapsed/hidden and the user will just have to expand it.
Thanks,
Al
"Al" <no@.no.com> wrote in message
news:%234JxHTWbHHA.2088@.TK2MSFTNGP05.phx.gbl...
> Good morning all:
> I am having an issue when jumping from one report to the next. The issue
> is that the users want the reports to run without having to enter any
> additional information but may want to change some of the parameters after
> the report has run. I have accomplished the first part of the requirement
> but the parameters are not showing themselves for the second part of the
> requirement.
> When I run the reports with out jumping to it the parameters are exposed
> and the user can select them but when it is called from another report
> they don't show at all.
> Is there some setting somewhere that will force the parameters to show
> even if they don't need to be modified?
> Thanks,
> Al
>|||Also, you can use Jump to URL. When you do that you can specify that the
parameter section is not collapsed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Al" <no@.no.com> wrote in message
news:uOzaIaWbHHA.4720@.TK2MSFTNGP04.phx.gbl...
> Never mind mystery solved. It turns out that the parameter area of the
> report is collapsed/hidden and the user will just have to expand it.
> Thanks,
> Al
> "Al" <no@.no.com> wrote in message
> news:%234JxHTWbHHA.2088@.TK2MSFTNGP05.phx.gbl...
>> Good morning all:
>> I am having an issue when jumping from one report to the next. The issue
>> is that the users want the reports to run without having to enter any
>> additional information but may want to change some of the parameters
>> after the report has run. I have accomplished the first part of the
>> requirement but the parameters are not showing themselves for the second
>> part of the requirement.
>> When I run the reports with out jumping to it the parameters are exposed
>> and the user can select them but when it is called from another report
>> they don't show at all.
>> Is there some setting somewhere that will force the parameters to show
>> even if they don't need to be modified?
>> Thanks,
>> Al
>>
>|||I can see that coming up. Thanks,
Al
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eQNiHzWbHHA.4544@.TK2MSFTNGP03.phx.gbl...
> Also, you can use Jump to URL. When you do that you can specify that the
> parameter section is not collapsed.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Al" <no@.no.com> wrote in message
> news:uOzaIaWbHHA.4720@.TK2MSFTNGP04.phx.gbl...
>> Never mind mystery solved. It turns out that the parameter area of the
>> report is collapsed/hidden and the user will just have to expand it.
>> Thanks,
>> Al
>> "Al" <no@.no.com> wrote in message
>> news:%234JxHTWbHHA.2088@.TK2MSFTNGP05.phx.gbl...
>> Good morning all:
>> I am having an issue when jumping from one report to the next. The
>> issue is that the users want the reports to run without having to enter
>> any additional information but may want to change some of the parameters
>> after the report has run. I have accomplished the first part of the
>> requirement but the parameters are not showing themselves for the second
>> part of the requirement.
>> When I run the reports with out jumping to it the parameters are exposed
>> and the user can select them but when it is called from another report
>> they don't show at all.
>> Is there some setting somewhere that will force the parameters to show
>> even if they don't need to be modified?
>> Thanks,
>> Al
>>
>>
>|||Yeah, sometimes it is easy to make a change than teaching people how to
expand the section.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Al" <no@.no.com> wrote in message
news:uuG8uFYbHHA.3584@.TK2MSFTNGP02.phx.gbl...
>I can see that coming up. Thanks,
> Al
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:eQNiHzWbHHA.4544@.TK2MSFTNGP03.phx.gbl...
>> Also, you can use Jump to URL. When you do that you can specify that the
>> parameter section is not collapsed.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Al" <no@.no.com> wrote in message
>> news:uOzaIaWbHHA.4720@.TK2MSFTNGP04.phx.gbl...
>> Never mind mystery solved. It turns out that the parameter area of the
>> report is collapsed/hidden and the user will just have to expand it.
>> Thanks,
>> Al
>> "Al" <no@.no.com> wrote in message
>> news:%234JxHTWbHHA.2088@.TK2MSFTNGP05.phx.gbl...
>> Good morning all:
>> I am having an issue when jumping from one report to the next. The
>> issue is that the users want the reports to run without having to enter
>> any additional information but may want to change some of the
>> parameters after the report has run. I have accomplished the first part
>> of the requirement but the parameters are not showing themselves for
>> the second part of the requirement.
>> When I run the reports with out jumping to it the parameters are
>> exposed and the user can select them but when it is called from another
>> report they don't show at all.
>> Is there some setting somewhere that will force the parameters to show
>> even if they don't need to be modified?
>> Thanks,
>> Al
>>
>>
>>
>

Parameters don't appear in drilledthrough report

Hi,
we created a "Start"-Report with a drillthrough via "Jump to Report" to an
"Linked"-Report
and both have parameters.
If we drillthrough from the Start-Report to the Linked-Report on the
SQL Server September CTP Reporting Services the parameters are not visibile
and we are
not able to make them visible. If we call the Linked-Report directly,
the parameters appear.
In the June CTP and in the preview of the September CTP everything works
fine and the parameters of both reports appear every time.
Any help will be appreciated.
RalphI'm running SQL2000 SP4 and Reporting Services SP2 but I'm having the same
problem on some reports. Others work fine. If you get an answer to this
problem please let me know. jlowther@.sta-home.com
--
John W. Lowther, Jr.
DBA / Senior Developer
Sta-home Health Agency
"bjh" wrote:
> Hi,
> we created a "Start"-Report with a drillthrough via "Jump to Report" to an
> "Linked"-Report
> and both have parameters.
> If we drillthrough from the Start-Report to the Linked-Report on the
> SQL Server September CTP Reporting Services the parameters are not visibile
> and we are
> not able to make them visible. If we call the Linked-Report directly,
> the parameters appear.
> In the June CTP and in the preview of the September CTP everything works
> fine and the parameters of both reports appear every time.
> Any help will be appreciated.
> Ralph
>
>|||John,
our problem was solved by the final release of SQL Server 2005.
It looks like is has been a bug in the September CTP.
The workaround used was to utilize "Jump to URL" instead of "Jump to Report"
Björn
"John Lowther" <johnlowther@.online.nospam> schrieb im Newsbeitrag
news:185FCD01-E94C-42DE-AD32-1335ECF7C158@.microsoft.com...
> I'm running SQL2000 SP4 and Reporting Services SP2 but I'm having the same
> problem on some reports. Others work fine. If you get an answer to this
> problem please let me know. jlowther@.sta-home.com
> --
> John W. Lowther, Jr.
> DBA / Senior Developer
> Sta-home Health Agency
>
> "bjh" wrote:
>> Hi,
>> we created a "Start"-Report with a drillthrough via "Jump to Report" to
>> an
>> "Linked"-Report
>> and both have parameters.
>> If we drillthrough from the Start-Report to the Linked-Report on the
>> SQL Server September CTP Reporting Services the parameters are not
>> visibile
>> and we are
>> not able to make them visible. If we call the Linked-Report directly,
>> the parameters appear.
>> In the June CTP and in the preview of the September CTP everything works
>> fine and the parameters of both reports appear every time.
>> Any help will be appreciated.
>> Ralph
>>

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
> >
> >
> >
> > --
> >
> >