Friday, March 9, 2012

publishing downloading report model

Hi friends

is it possible download a report model (.smdl) from a report server?

and also how to publish a report model?

i know how to do this from report manager page but i need to do this programmatically (from C#).

any ideas please. Thanks.

any ideas dudes ?

Thanks for ur help.

|||

publish model using SOAP method CreateModel, then bind it to a data source using SetItemDataSources

|||

Thank you very much Lev.i'll use that method to upload.

BTW i cant find any method to download a model mate ?

any ideas?

Thanks for ur help again.

|||GetModelDefinition|||

Thanks for that Lev. thats what am looking for.

BTW is there any sample code on these methods ?

|||Hi Lev
thanks for that . i finally able to upload a report model using "createModel" but after uploading i still need to set its data source manually from report manager page to get it work!

as you know "createModel" has parameter called "property[]" ,can i use it to set data source ? if so how can i please ?

or you said i could use "setItemDatasources" but i cant figure out how to use this one ?

can you help ?
Thanks
|||BTW Lev
how can i overwrite the report model if already exists?
at the moment am getting following exception

System.Web.Services.Protocols.SoapException: The item '/Models/copyofORM' already exists.

Thanks.|||

Here is some sample code that may give you some ideas:

http://www.sqldbatips.com/samples/code/RSScripter/readme.htm#_script_model

|||

prk wrote:

how can i overwrite the report model if already exists?
at the moment am getting following exception

System.Web.Services.Protocols.SoapException: The item '/Models/copyofORM' already exists.

It is not possible to override model with different model. You have to delete existing model first (note, that this will break all reports using that model)

|||

Lev Semenets - MSFT wrote:

It is not possible to override model with different model. You have to delete existing model first (note, that this will break all reports using that model)

Lev

actually am not overwriting with different model. first i download what already there ,make few changes and re upload the model.

when we upload a model from report manager page ,as you know, there is an option to overwrite , i wonder if we can do same thing programmatically ?

|||

Lev Semenets - MSFT wrote:

Here is some sample code that may give you some ideas:

http://www.sqldbatips.com/samples/code/RSScripter/readme.htm#_script_model

Thats wonderful Lev.

will go thru all examples here. Thanks for ur time and help :)

No comments:

Post a Comment