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|||

I have tried to create a script in MS SQL Server Management Studio that uploads Excel to SRS.

(I shortened the numbers that represent the excel file for brevity)

Public Overridable Sub Main()

CreateResource

End Sub

Private Sub CreateResource()

Dim Resource As String = "CARDAPPTS"

Dim Parent As String = "/Cardiology/Weekly Appointments"

Dim Overwrite As Boolean = true

Dim Contents() As Byte = New Byte() {208, 207, 17, 224, 161, 177, 26, 225, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 62, 0, 3, 0, 254, 255, 9, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 113, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 254, 255, 255, 255, 0, 0, 0, 0, 254, 255, 255, 255, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 96, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 5, 0, 68, 0, 111, 0, 99, 0, 117, 0, 109, 0, 101, 0, 110, 0, 116, 0, 83, 0, 117, 0, 109, 0, 109, 0, 97, 0, 114, 0, 121, 0, 73, 0, 110, 0, 102, 0, 111, 0, 114, 0, 109, 0, 97, 0, 116, 0, 105, 0, 111, 0, 110, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56, 0, 2, 1, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 104, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0}

Dim MimeType As String = "application/vnd.ms-excel"

Dim Properties(-1) As Microsoft.SqlServer.ReportingServices2005.[Property]

RS.CreateResource(Resource, Parent, Overwrite, Contents, MimeType, Properties)

End Sub

When I try to run it with rs.exe, I get error: BC30451: Name 'Contents' is not declaired.

Is there a way to automate uploading Excel files using rs.exe?

I am trying to avoid uploading 500 spreadsheets manually through the MS SQL Server Management Studio. (We are doing this in the interim until the 500 reports can be built in RS)

Any help is appreciated.

sql