Hi all! Anyone has an example how to deploy rdl (sql 2008 r2) reports by .net programming? I have to create an assembly that will used by my installer sotware to deploy my reports to the Reporting Server 208 R2. The only examples found were for SQL 2005. Best regards!

There's documentation for the ReportingServer2010 class, which contains the methods you'll need to utilise to deploy the reports. Specifically you'll be interested in CreateCatalogItem - http://msdn.microsoft.com/en-us/library/reportservice2010.reportingservice2010.createcatalogitem.aspx. There's some very relevant sample code down the bottom of the page also :)David Stewart | My Blog | Follow me on Twitter

All examples for 2005 will work fine. SSRS 2008 R2 include classes: ReportingServer2005, ReportingServer2008, and ReportingServer2010 and you can invoke any of them. Look also for examples of rs utility deploy script: http://www.simple-talk.com/sql/reporting-services/deploying-reports-using-the-reportingservices2005-class-and-the-rs-utility/ You can directly copy this script into assembly by just adding correct web reference to your project (you can find detailed instructions below): http://dbaspot.com/ms-sqlserver/233312-using-rs-exe-command-line-utility-execute-reports.html

Thank you very much!

When I use the example from the msdn I get this error for the credential value : client.ClientCredentials = System.Net.CredentialCache.DefaultCredentials; // Cannot implicity convert type 'System.Net.ICredentials' to 'System.ServiceModel.Description.ClientCredentials'. An explicit conversion exists (are you missing a cast?) When I cast like this, I get this error : client.ClientCredentials = System.Net.CredentialCache.DefaultCredentials as ClientCredentials; // ClientCredentials can not be assigned to -- it is read only I'm not experienced with the CredentialCache. Could you help me please?

Which example from MSDN are you trying to use?David Stewart | My Blog | Follow me on Twitter

I found the problem. I did a service reference... the solution was to create a web reference in visual studio. Thanks.