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
There is a sample script that comes with the RS installation. Also, the
Hope that help,
-
This posting is provided "AS IS" with no warranties, and confers no rights.
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