SQL Server - Reporting Services
Reporting Services Tip #3 - rs.exe, backslash problem
In a previous blog, I wrote how you can deploy your reports via Report Manager. It was mentioned in the comments section that "you can use the web service to upload the RDL directory from code". Recently, I started to look into this so that deploying reports would be easier, that is without the deploy option in Visual Studio.
Reporting Services comes with a command line utility, rs.exe, that allows you to administer Report Server via scripts that run Web Service operations. These scripts must be written in VB.NET and a suggested extension...
Reporting Services Tip #2:
The easiest way to install Reporting Services is to have the Report Server and SQL Server on the same server. It's the easiest way, but it certainly is not the best. IIS should not be installed on the database server for performance reasons. Now this isn't true for small systems, but I rarely work on small systems so this is a general rule for me. Due to this rule, the Report Server must be installed on a different server as it relies on IIS. And yes this way requires the Report Server to be licensed as well...
SQL Server 2000 Reporting Services Service Pack 1 has been released. You can download it here.
I've been working on SQL Server 2000 Reporting Services for the past couple of weeks. I plan on blogging about my experience by providing tips.
Reporting Services Tip #1:
If you've created a report that you would like to deploy to a server without using Report Designer, you can upload the rdl file in Report Manager.
We've got a disconnected network where we can not connect to production except through the web application, Citrix, or by walking down to the production server room. This means that we can not deploy the reports through Report Designer from our own desktop. So, all that we...
I attended the SQL Server Reporting Services event yesterday in San Diego. I hadn't downloaded the beta version of it, so this was my first look at the product. I was impressed with it. But now I have to get IIS and VS .NET installed in order to use it, which is going to be a pain since my MSDN subscription expired (it's being renewed but that'll take a couple of weeks).
As a DBA, you are often asked to query production data because the application doesn't provide what is needed. We plan on using Reporting Services to create a few...