Deploying a report model programatically

Hi,
I would like to know how can I deploy a report model programatically in SQL
server 2005? Or if there is any other way to distribute report models.
Thanks in advance,
NiravI'm curious to find out as well...
Would it be possible to edit the RDLC files programmatically then
deploy them? RDLC files are basically XML files anyway. It would be
nice to customize a given report format based on the user that
requested it...|||You can use the CreateModel and SetModelDefinition methods of the
ReportingService2005 object to create or update a model on a ReportServer.
To get the definition from a server you would use the GetModelDefinition
method. Scripting and Transfering models are part of the features of v2 of
Reporting Services Scripter which should be available in the next few weeks
from my site
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Nirav" <Nirav@.discussions.microsoft.com> wrote in message
news:D5342964-33E3-42FC-8B1A-6DD23B8016B9@.microsoft.com...
> Hi,
> I would like to know how can I deploy a report model programatically in
> SQL
> server 2005? Or if there is any other way to distribute report models.
> Thanks in advance,
> Nirav|||So after I do my editing to the RDLC file a call to SetModelDefinition
would be just like replacing the currently deployed RDLC file on the
Reporting Services Report Server? and any further report render
requests for the report defined by the updated RDLC will be rendered
with the changes I just made?|||Ok, I could deploy both the model and the required datasource through the
ReportingService2005 web service. Now I need to link them (setting the
published datasource for the model), otherwise my report will not execute. I
tried to use SetItemDataSources web method, but that throws an exception for
the model. Any ideas?
Thanks in advance.
"Nirav" wrote:
> Hi,
> I would like to know how can I deploy a report model programatically in SQL
> server 2005? Or if there is any other way to distribute report models.
> Thanks in advance,
> Nirav