Welcome to MSDN Blogs Sign in | Join | Help

July 2006 - Posts

Sunday, July 30, 2006 8:10 AM

Yummy Reporting Services / SharePoint Integration in SQL Server 2005 SP2

I attended TechReady3 last week, and one of the most interesting sessions focused on the work the SSRS team has done around Reporting Services / SharePoint integration in SQL Server 2005 Service Pack 2 (due next year). As you know, we already have SharePoint
Posted by russch | 32 Comments
Thursday, July 27, 2006 12:57 PM

Reporting Services rendering performance improvements in Katmai

I'm attending TechReady3 (an MSFT technical training event), and just sat through a great session on SSRS led by Chris Baldwin. Among other things he mentioned was a major emphasis on rendering performance (especially for Excel and PDF & memory use)
Posted by russch | 0 Comments
Friday, July 21, 2006 3:03 PM

SQL 2005 Books Online refresh #3 and updated samples for July just released

BOL: http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en Samples: http://www.microsoft.com/downloads/details.aspx?FamilyID=e719ecf7-9f46-4312-af89-6ad8702e4e6e&DisplayLang=en
Posted by russch | 0 Comments
Thursday, July 20, 2006 3:28 PM

More fun with expression-based connection strings in Reporting Services

Books online has a good explanation of what you can do with expression-based connection strings in the help topic "Connecting to a Data Source" ( http://msdn2.microsoft.com/en-us/library/ms156450.aspx ). For example, it shows you how to dynamically change
Posted by russch | 11 Comments
Wednesday, July 19, 2006 3:34 PM

Using a parameterized SSIS package as a data source for SQL Reporting Services

As you may know, SSRS reports can use Integration Services packages as a source of data. This technique opens up some interesting possibilities around pre-processing data before it is rendered in a report. I’m going to take this one step further and describe
Posted by russch | 39 Comments
Friday, July 07, 2006 9:11 AM

Unloading & Loading Reporting Services 2005 perfmon counters

If you need to unload and/or reload the SSRS 2005 perfmon counters for any reason, here's how: Use unlodctr against the name of the object as it appears in the list of Perfomance Objects in perfmon. You can also find this name in the .ini files for each
Posted by russch | 0 Comments
 
Page view tracker