Tuesday, March 27, 2012

changing the RDL at run time

Does the RS need RDL once the report is deployed. I need to change the RDL at
run time.Although there is no rdl file on the webserver, when you deploy it the rdl
gets stored in the database. The database is where RS retrieves the report.
If you change the rdl at runtime you have to deploy the report before it can
be viewed. This is possible but keep in mind, you would need to uniquely
name the report for the current user you are modifying the rdl for otherwise
if two people try to view the same report they will see whichever was the
latest you modified and deployed. Most people that do this are using web
services to accomplish this. Although doable it is non-trivial. I would make
sure that there is not some other way around your problem before going this
route.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"vcs" <vcs@.discussions.microsoft.com> wrote in message
news:00D56442-ABC3-48E9-9BE7-285198BA14C2@.microsoft.com...
> Does the RS need RDL once the report is deployed. I need to change the RDL
at
> run time.

No comments:

Post a Comment