Deployment

Hello,

I was reading some article which said, the reporting service (sql server 2005)does
not have many capabilities and so, after initial development of reports you
can deploy it to a custom website or an application and then use .net to
enhance report functionalities...

How to do this..Please help me.!

Thanks,Shankar - do you have a specific question about deployment?

Reporting services provides for many reporting capabilities and deployment options. These are documented in the Books Online that comes with the product. Please use this as your first reference when evaluating the product's capabilities.

Good luck,

-Lukasz|||Hi,

When reading the Books Online for SQL Server 2000 Reporting Services I can see two different ways for deployment described.

1. Deploy from Report Designer
2. Upload files in Report Manager

Is there any way to automate the deployment in this version by using MSI or some other 'deployment' product?
// Jarle|||

Yes - the report server provides a SOAP API that you can call from applications (e.g. a custom action in MSI setup). We also provide a utility called rs.exe which can execute VB.Net based script files. It lets you manage report server by writing command line scripts then executing them against the report server.

There is a sample script that comes with the RS installation. Also, the SOAP API is documented in Books Online.

Hope that help,
-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||Ahh - great! Exactly what I was looking for.

Thanks for the help!
// Jarle