Using an External DataSet with Reporting Services Reports

A colleague of mine working at the SQL Server Developer Center has written a short article on Reporting Services and DataSet data processing. You can view it here: http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql2k/html/rsdsetex3.asp

0

Writing Custom Code for Reporting Services Reports

Teo Lachev has published a partial chapter of his new book “Microsoft Reporting Services in Action” to the Microsoft Developer Network (MSDN) online. The excerpt comes complete with sample code available as a download. Special thanks to Teo and to Manning Publication for allowing this content to be made available to Reporting Services customers. Read…

0

GetReportParameters method

I stumbled across this short article on using the Reporting Services SOAP API to retrieve parameter information for a report by K. Scott Allen. Visit http://odetocode.com/Articles/123.aspx

3

Welcome Tudor to Reporting Services Blogging

Just wanted to let you know that Tudor has started a Reporting Services blog. As some of you may know, Tudor is the lead developer for the Reporting Services product and thereby an instrumental part of its design and development. His first post on Measuring and Improving Performance is worth a read.

1

Reporting Services Service Pack 1 Now Available!

SP1 of Reporting Services can be downloaded from the following site: http://www.microsoft.com/downloads/details.aspx?FamilyId=580FEBF7-2972-40E7-BCCF-6CD90AC2F464&displaylang=en It contains the following new enhancements and fixes: Excel rendering extension has been improved and now supports viewing in Excel 97 and 2000. PDF rendering extension is more robust and has better performance. Chart control provides more control over display styles. References to…

2

Reporting Services WebParts – Walkthrough

Check out Bryant Likes’ blog for a nice walkthrough on setting up Reporting Services WebParts for SharePoint.

3

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…

10

You’ve just installed Reporting Services, now back up that encryption key!

I presented some demos at this year’s PASS (Professional Association of SQL Server) Community Summit on how to use the rskeymgmt utility in Reporting Services. This is a crucial tool and should be used after every Reporting Services installation. What is it good for? Well, it can do several things, least of which is to extract…

3

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…

13

Sample Script for Setting Item-level Security

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…

1