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 defined in .rdl and how they are applied in Report Manager

One of my reports is defined as follows in .rdl:

<ReportParameter Name="ExplicitProject">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Agile_1029c</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>ExplicitProject</Prompt>
</ReportParameter>

In Report Manager, I have overriden this value by specifying that the default value be an empty string. The report uses the value I specified in Report Manager.

How does this work? Where does Report Server store the overriden definition? There seem to be two places where the rendering is getting its specification. Is there a hierarchy i.e. first check .rdl, then check (wherever the overrides are stored?)

Kind Regards
Jean-Pierre

The overridden parameters are stored in the report catalog. If you override the report parameters in the Report Manager and subsequently deploy the report definition with new default values, you will find that the parameter default values don't change. This is done to favor the report administrators. You can only change default values of a deployed report programatically. The other option is to delete the report and re-deploy.|||

Thank you Teo. THis has been of great help.

parameters default value remains "Query based" in spite of setting

Hello,
In my report manager I am not able to set a default value for a report
parameter, because the default value is indicated to be "query based".
I do not seem to be able to change that whatever I do. Surely I tried
setting the report parameters to "non-queried" and "none".
The default values I set in report designer also do not show in the
deployed report. (Even though other changes do.)
Anybody some ideas? Thanks.In Solution Explorer, right-click on the Project and choose Properties. Change OverwriteDataSources
to True and redeploy.
Optionally, you can use Report Manager (http://yourserver/reports) to do this by navigating to the
report you want to modify, clicking the Properties tab and selecting Data Sources on the left. You
can them make your changes on the server.
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul vO" <info@.vanoordt.nl> wrote in message
news:200e5c1b.0408230349.39c8c5d0@.posting.google.com...
> Hello,
> In my report manager I am not able to set a default value for a report
> parameter, because the default value is indicated to be "query based".
> I do not seem to be able to change that whatever I do. Surely I tried
> setting the report parameters to "non-queried" and "none".
> The default values I set in report designer also do not show in the
> deployed report. (Even though other changes do.)
> Anybody some ideas? Thanks.

Parameters Caching?

Hello,
I've created a report (with default parameters) and uploaded it to Report
Manager.
When I later change the default parameters in the RDL and "Update" the
report definition, the default parameters do not update in Report Manager.
When I remove the report definition and re-upload it, the report parameters
are once again updated.
My theory is that when I upload a report, the parameters are stored in a
table in the ReportServer database, and pulled from there no matter what is
contained in the report definition. If this is the case, is there a way to
"Refresh" the default parameters?
Any assistance would be greatly appreciated.
Best Regards,
BenAfter you deploy the report to the server with the change. Close IE and
re-open it. You should see the new report then.
Bruce L-C
"Benjamin Pierce" <bpierce@.opentext.com> wrote in message
news:OWB78$vfEHA.644@.tk2msftngp13.phx.gbl...
> Hello,
> I've created a report (with default parameters) and uploaded it to Report
> Manager.
> When I later change the default parameters in the RDL and "Update" the
> report definition, the default parameters do not update in Report Manager.
> When I remove the report definition and re-upload it, the report
parameters
> are once again updated.
> My theory is that when I upload a report, the parameters are stored in a
> table in the ReportServer database, and pulled from there no matter what
is
> contained in the report definition. If this is the case, is there a way
to
> "Refresh" the default parameters?
> Any assistance would be greatly appreciated.
>
> Best Regards,
> Ben
>|||Hello,
I've attempted to refresh the report (and have cleared my cache), but to no
avail.
If I issue this query, I can see that the old parameters are still sitting
in the catalog table.
SELECT Parameter FROM Catalog
It looks like updating a report definition on your report manager doesn't
actually change the default parameters in the Catalog table, even if they
have changed in the updated RDL.
Does this seem like a bug to anybody? I'm more than happy to provide an
easy to setup example if requested.
Thanks again,
Benjamin Pierce
Open Text Corporation
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:O%23BKBJwfEHA.1428@.TK2MSFTNGP10.phx.gbl...
> After you deploy the report to the server with the change. Close IE and
> re-open it. You should see the new report then.
> Bruce L-C
> "Benjamin Pierce" <bpierce@.opentext.com> wrote in message
> news:OWB78$vfEHA.644@.tk2msftngp13.phx.gbl...
> > Hello,
> >
> > I've created a report (with default parameters) and uploaded it to
Report
> > Manager.
> >
> > When I later change the default parameters in the RDL and "Update" the
> > report definition, the default parameters do not update in Report
Manager.
> > When I remove the report definition and re-upload it, the report
> parameters
> > are once again updated.
> >
> > My theory is that when I upload a report, the parameters are stored in a
> > table in the ReportServer database, and pulled from there no matter what
> is
> > contained in the report definition. If this is the case, is there a way
> to
> > "Refresh" the default parameters?
> >
> > Any assistance would be greatly appreciated.
> >
> >
> > Best Regards,
> >
> > Ben
> >
> >
>|||It is actually our design, although an arguably strange one. Report
parameters can be modified after the report has been published and we
decided to favor the admin over the developer and not overwrite them by
default when the report definition is changed. If you want to do so, you
would need to call SetReportParameters after SetReportDefinition.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Benjamin Pierce" <bpierce@.opentext.com> wrote in message
news:uzXTMVwfEHA.3928@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I've attempted to refresh the report (and have cleared my cache), but to
no
> avail.
> If I issue this query, I can see that the old parameters are still sitting
> in the catalog table.
> SELECT Parameter FROM Catalog
> It looks like updating a report definition on your report manager doesn't
> actually change the default parameters in the Catalog table, even if they
> have changed in the updated RDL.
> Does this seem like a bug to anybody? I'm more than happy to provide an
> easy to setup example if requested.
>
> Thanks again,
> Benjamin Pierce
> Open Text Corporation
>
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:O%23BKBJwfEHA.1428@.TK2MSFTNGP10.phx.gbl...
> > After you deploy the report to the server with the change. Close IE and
> > re-open it. You should see the new report then.
> >
> > Bruce L-C
> >
> > "Benjamin Pierce" <bpierce@.opentext.com> wrote in message
> > news:OWB78$vfEHA.644@.tk2msftngp13.phx.gbl...
> > > Hello,
> > >
> > > I've created a report (with default parameters) and uploaded it to
> Report
> > > Manager.
> > >
> > > When I later change the default parameters in the RDL and "Update" the
> > > report definition, the default parameters do not update in Report
> Manager.
> > > When I remove the report definition and re-upload it, the report
> > parameters
> > > are once again updated.
> > >
> > > My theory is that when I upload a report, the parameters are stored in
a
> > > table in the ReportServer database, and pulled from there no matter
what
> > is
> > > contained in the report definition. If this is the case, is there a
way
> > to
> > > "Refresh" the default parameters?
> > >
> > > Any assistance would be greatly appreciated.
> > >
> > >
> > > Best Regards,
> > >
> > > Ben
> > >
> > >
> >
> >
>|||Thank you sir!
Your workaround is quite acceptable.
Regards,
Benjamin Pierce
"Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
news:ulCejkwfEHA.3024@.TK2MSFTNGP10.phx.gbl...
> It is actually our design, although an arguably strange one. Report
> parameters can be modified after the report has been published and we
> decided to favor the admin over the developer and not overwrite them by
> default when the report definition is changed. If you want to do so, you
> would need to call SetReportParameters after SetReportDefinition.
> --
> Tudor Trufinescu
> Dev Lead
> Sql Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Benjamin Pierce" <bpierce@.opentext.com> wrote in message
> news:uzXTMVwfEHA.3928@.TK2MSFTNGP11.phx.gbl...
> > Hello,
> >
> > I've attempted to refresh the report (and have cleared my cache), but to
> no
> > avail.
> >
> > If I issue this query, I can see that the old parameters are still
sitting
> > in the catalog table.
> >
> > SELECT Parameter FROM Catalog
> >
> > It looks like updating a report definition on your report manager
doesn't
> > actually change the default parameters in the Catalog table, even if
they
> > have changed in the updated RDL.
> >
> > Does this seem like a bug to anybody? I'm more than happy to provide an
> > easy to setup example if requested.
> >
> >
> > Thanks again,
> >
> > Benjamin Pierce
> > Open Text Corporation
> >
> >
> > "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:O%23BKBJwfEHA.1428@.TK2MSFTNGP10.phx.gbl...
> > > After you deploy the report to the server with the change. Close IE
and
> > > re-open it. You should see the new report then.
> > >
> > > Bruce L-C
> > >
> > > "Benjamin Pierce" <bpierce@.opentext.com> wrote in message
> > > news:OWB78$vfEHA.644@.tk2msftngp13.phx.gbl...
> > > > Hello,
> > > >
> > > > I've created a report (with default parameters) and uploaded it to
> > Report
> > > > Manager.
> > > >
> > > > When I later change the default parameters in the RDL and "Update"
the
> > > > report definition, the default parameters do not update in Report
> > Manager.
> > > > When I remove the report definition and re-upload it, the report
> > > parameters
> > > > are once again updated.
> > > >
> > > > My theory is that when I upload a report, the parameters are stored
in
> a
> > > > table in the ReportServer database, and pulled from there no matter
> what
> > > is
> > > > contained in the report definition. If this is the case, is there a
> way
> > > to
> > > > "Refresh" the default parameters?
> > > >
> > > > Any assistance would be greatly appreciated.
> > > >
> > > >
> > > > Best Regards,
> > > >
> > > > Ben
> > > >
> > > >
> > >
> > >
> >
> >
>