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