MSDN Blogs

Posts

| |

Russell Christopher's Semi-Useful BI Musings

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

Posted over 8 years ago

by Russell Christopher
- 26 Comments
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...
Russell Christopher's Semi-Useful BI Musings

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

Posted over 8 years ago

by Russell Christopher
- 0 Comments
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...
Russell Christopher's Semi-Useful BI Musings

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

Posted over 8 years ago

by Russell Christopher
- 16 Comments
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...
Russell Christopher's Semi-Useful BI Musings

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

Posted over 8 years ago

by Russell Christopher
- 4 Comments
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...
Russell Christopher's Semi-Useful BI Musings

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

Posted over 8 years ago

by Russell Christopher
- 8 Comments
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...
Russell Christopher's Semi-Useful BI Musings

Automatically refreshing your SQL Reporting Services reports with the AutoRefresh element

Posted over 8 years ago

by Russell Christopher
- 14 Comments
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...
Russell Christopher's Semi-Useful BI Musings

Multi-column interactive sort in SQL Reporting Services 2005

Posted over 8 years ago

by Russell Christopher
- 13 Comments
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...
Russell Christopher's Semi-Useful BI Musings

Is SQL Reporting Services 2000 / 2005 cluster aware?

Posted over 8 years ago

by Russell Christopher
- 0 Comments
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...
Russell Christopher's Semi-Useful BI Musings

What to do after renaming your Report Server

Posted over 8 years ago

by Russell Christopher
- 0 Comments
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...
Russell Christopher's Semi-Useful BI Musings

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

Posted over 8 years ago

by Russell Christopher
- 14 Comments
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...
Russell Christopher's Semi-Useful BI Musings

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

Posted over 8 years ago

by Russell Christopher
- 1 Comments
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,...
Russell Christopher's Semi-Useful BI Musings

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

Posted over 8 years ago

by Russell Christopher
- 0 Comments
http://whidbey.msdn.microsoft.com/library/?url=/library/en-us/rs_vsrpts/html/0334cfba-2cb7-4d8b-8927-e08b888450cd.asp?frame=true
Russell Christopher's Semi-Useful BI Musings

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

Posted over 8 years ago

by Russell Christopher
- 59 Comments
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...