Welcome to MSDN Blogs Sign in | Join | Help

March 2006 - Posts

Wednesday, March 29, 2006 2:25 PM

Using SQL 2000 for SSRS 2005 metadata storage

When setting up SQL Server Reporting Services 2005, can you use SQL 2000 as the host for the reportserver database? Yes, you can (with an obvious caveat in one scenario). How? Scenario 1: SQL Server 2000 currently is not running SSRS, so it does not host
Posted by russch | 23 Comments
Friday, March 24, 2006 11:58 AM

Using the XML Data Extension to leverage an ADO.NET dataset in your SQL Reporting Services Report.

Here's a quick walkthrough on how to return records in an ADO.NET dataset (via a Web Service) and use them in a report. Many, many, many thanks to Ian Roof and Mary Lingel for forcibly pushing me in the right direction when I was clueless. First, here's
Posted by russch | 23 Comments
Tuesday, March 21, 2006 8:12 AM

SQL Server 2005 Express Edition and Reporting Services -- At last!

Yesterday, Microsoft released the CTP of SQL Express with Advanced Services. You can use this distro to get SSRS functionality in Express. Here's the section of the readme that applies to "us" (bold is mine): 4.2 Creating Reports by Using Reporting Services
Posted by russch | 3 Comments
Monday, March 20, 2006 11:19 AM

Good articles around using the ReportViewer control by Teo Lachev

Just stumbled upon two articles by Teo Lachev which provide an excellent overview of the ReportViewer controls along with "real world" scenarios around how you can leverage them. The articles include some yummy sample code, too. Find them here: http://www.devx.com/dotnet/Article/30424
Posted by russch | 0 Comments
Monday, March 20, 2006 9:45 AM

SQL Server 2005 SP1 CTP Available

See Brian's blog for into about the newly released SP1 CTP and what it means to SSRS users http://blogs.msdn.com/bwelcker/archive/2006/03/16/553262.aspx
Posted by russch | 0 Comments
Monday, March 20, 2006 9:36 AM

Good post on Model Security

Bob Meyers posted a really good write-up on various ways to secure your report model! http://blogs.msdn.com/bobmeyers/articles/Implementing_Data_Security_in_a_Report_Model.aspx
Posted by russch | 0 Comments
Monday, March 06, 2006 5:33 PM

SSL and SQL Reporting Services 2005

While setting up a Report Server to run with SSL, one of my customers repeatedly got the following error message: " The underlying connection was closed: Could not establish trust relationship with remote server ." The interesting thing was that the /Reports
Posted by russch | 5 Comments
Friday, March 03, 2006 1:44 PM

Using "Scale-Out" deployments In SQL Server Reporting Services 2005

Today I really played around with scale out deployments in 2005 (known as "reporting farms" in earlier versions) for the first time since I worked with them in 2000, and found an interesting behavior: I wanted to point my 2005 Enterprise Edition at a
Posted by russch | 9 Comments
Wednesday, March 01, 2006 5:34 PM

Deploying a SQL Server Reporting Services 2005 report via an MSI

Most of the time, it’s acceptable for customers to deploy a report manually via Visual Studio, Report Manager, or maybe by using an rss script. Last month I bumped into an organization that had a hard and fast rule that “anything deployable” (Winform
Posted by russch | 16 Comments
Attachment(s): PublishReportWithMSI.zip
 
Page view tracker