Printing Reports Programmatically Using C# and SQL Server 2000 Reporting Services

Summary: Learn a technique for printing reports programmatically using the Reporting Services XML Web service and C#. Microsoft SQL Server 2000 Reporting Services is Microsoft’s latest entry into the Business Intellegence marketplace and it joins a host of other BI products for SQL Server 2000. Reporting Services is a new, server-based reporting platform that you can…


Accessing a Report Server Using a URL POST Request

You may have a need to access a report server, not through GET requests or standard browser access, but through POST requests. The times when you might need to use a POST request in your application are as follows:  You need to build a custom user interface with your own toolbar, parameters area, report exporting features, etc. This is often…


Sample Script for Setting Item-level Security in Reporting Services

Report Manager is a solid, Web-based administrative tool for Reporting Services, but it is not the end-all-be-all of administrative functionality for a report server. There are many capabilities available through the Web service that Report Manager does not take advantage of. Case in point: Setting a security policy (otherwise known as a role assignment) for an…


How hard is it to write Reporting Services extensions?

Obviously the answer to this question is fraught with conditions and dependencies. In general terms, this would be my answer (from easiest to most difficult):   Data Processing Extensions: Built on the same framework as ADO.NET, a Reporting Services data processing extension models .NET data providers in many ways. They are fairly straight forward to…


Clarification on the Placement of CodeGroup Elements for Extensions

Well, I’ve been away for a while, lots of stuff going on at work and home. The next series of posts are going to be related to corrections and/or updates to Reporting Services Programming documentation. The first subject I would like to cover is the placement of CodeGroup elements when granting permissions to external components (extensions and custom assemblies) in Reporting…


Accessing a Report Server Using a URL POST Request

If anyone is interested in a simple example of how to access a report server using a form post action, you can check out a short article here.


Windows Installer Requirement and the SMS 2003 Inventory Tool for Microsoft Updates

I want to provide some clarification regarding the Windows Installer 3.1 requirement for the newly released SMS 2003 Inventory Tool for Microsoft Updates. This tool provides integration with the Windows Update Agent and the catalog of updates available on Windows Update and Microsoft Update to enterprise customers.   You may notice that the tool has…


Impersonate in Reporting Services ASP.NET Web Clients

This issue comes up quite often with users who are building client Web applications that use the Reporting Services Web service. When you develop ASP.NET client applications that generate a Web service proxy, you can authenticate the current user to the Web service in your code. However, in ASP.NET, impersonation is turned off by default. This means that…


SMS 2003 R2 Brings Custom Application Updating to Systems Management Server

I am very pleased to announce the release of Systems Management Server 2003 R2. It has been a real thrill to work on a new set of features for the SMS 2003 product. In my opinion, R2 includes one of the most exiting new innovations in systems management, namely, custom update management. Custom update management refers to the ability…


Issue for SMS customers deploying MS06-007 who have AU and ITMU running

After the release of MS06-007 on Tuesday 14 February 2006, Microsoft became aware of an issue affecting  the installation of MS06-007. Microsoft quickly investigated the issue and determined that customers who attempted to install the MS06-007 security updates through Automatic Updates, Windows Update, Windows Server Update Services and Systems Management Server 2003 when using the…