Welcome to MSDN Blogs Sign in | Join | Help

July 2005 - Posts

Friday, July 29, 2005 3:17 PM

How to prevent empty reports from being sent as part of a SQL Reporting Services subscription

It's pretty common to set up report subscriptions which are based on queries that can filter data based on sliding date ranges. So, at times you may end up with a report which does not contain any data. Do you want to send an essentially empty report
Posted by russch | 8 Comments
Wednesday, July 27, 2005 1:53 PM

Field Name Resolution in SQL Reporting Services 2005's Report Builder

If you've played around with Report Builder, you have probably used the Formula builder to modify an expression in your report or create a brand new field to display in a data region. If any of the expressions that you build reference a field/attribute
Posted by russch | 0 Comments
Tuesday, July 26, 2005 2:42 PM

Bet you don't know about these SQL Reporting Services perfmon counters

Thanks to Tudor Trufinescu and Matthew Hofacker for getting into a discussion on these suckers! As you know, SQL Reporting Services ships with a slew of perfmon counters. However, there are some additional counters which are undocumented and must be activated
Posted by russch | 11 Comments
Friday, July 15, 2005 11:38 AM

Checking the version of Reporting Services you're running 2000/2005

I was suprised that I couldn't find a complete list of "build number to service pack" mappings for SQL Server 2000 Reporting Services anywhere... So, here they are: 2000: RTM: 8.00.743.00 SP1: 8.00.878.00 SP2: 8.00.1038.00 SP2 with KB901383 Hotfix: 8.00.1042.00
Posted by russch | 4 Comments
Thursday, July 14, 2005 3:01 PM

Testing dataset queries which utilize multi-value parameters in SQL Server 2005 Reporting Services

Normally, when you have a dataset query which is filtered by a parameter (like the one below), it's easy to test it in the query design tool: SELECT field1,field2 FROM table WHERE field3 = @someParameter ...you simply click the "!" button on the toolbar,
Posted by russch | 6 Comments
Wednesday, July 13, 2005 1:39 PM

Automatically refreshing your SQL Reporting Services reports with the AutoRefresh element

If want your report to auto refresh every x seconds inside IE, take a look at the AutoRefresh RDL element: <AutoRefresh> is a child of <Report> and a peer or the <Body> element in your document. For example, if you want your report to
Posted by russch | 10 Comments
Tuesday, July 12, 2005 10:37 AM

Multi-column interactive sort in SQL Reporting Services 2005

I've seen Brian Welcker (a group PM for SSRS - http://blogs.msdn.com/bwelcker/default.aspx ) do a few demos in which he showed the new interactive sort capability of SQL Server Reporting Services 2005: It allows the user to sort columns in a report without
Posted by russch | 11 Comments
Monday, July 11, 2005 9:58 AM

Is SQL Reporting Services 2000 / 2005 cluster aware?

I've asked this question myself, and seen lots of people do the same too...the answer is no. Neither version of SSRS is cluster aware. However, since SQL itself is cluster aware, you pretty much get what you need (as long as you are using a web/reporting
Posted by russch | 0 Comments
Monday, July 11, 2005 9:54 AM

What to do after renaming your Report Server

Nothing earth shaking here. Just posting this so I can point others to the steps quickly. If you rename the box/domain name that SQL Server 2000 was installed on, here's how you get RS up and running again: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_customizing_v1_476q.asp?frame=tru
Posted by russch | 0 Comments
Friday, July 08, 2005 12:51 PM

How to hide items in the HTML Toolbar control for SQL Server 2000 Reporting Services

This is kind of old news since the feature has been around since SP1, but I haven't really played around with it until now: You can control the look and feel of the HTML report toolbar by using a custom cascading stylesheet and URL Access. If you take
Posted by russch | 13 Comments
Thursday, July 07, 2005 12:46 PM

RGDI and the Winform Report Viewer control in SQL Server 2005 Reporting Services

While playing around with report rendering in 2005, I noticed RGDI (for example, in CTP15 use Report Manager to create a subscription using the File Share delivery extension and you'll see "Remote GDI+ file" in the list of render formats). Anyway, the
Posted by russch | 1 Comments
Friday, July 01, 2005 2:27 PM

Good information on using the Report Viewer controls with SQL Reporting Services 2005

http://whidbey.msdn.microsoft.com/library/?url=/library/en-us/rs_vsrpts/html/0334cfba-2cb7-4d8b-8927-e08b888450cd.asp?frame=true
Posted by russch | 0 Comments
Friday, July 01, 2005 10:26 AM

"A data source instance has not been supplied for the data source" exception w/ Report Viewer Control

I'm using the webform Report Viewer control and I want to render a report locally on SQL Server Reporting Services 2005, CTP15. After creating the report, I pointed its data source at a SQLDataSource to pull information from the AdventureWorks database.
Posted by russch | 42 Comments
 
Page view tracker