Russell Christopher's Semi-Useful BI Musings - All Comments

re: Formatting currency on a row-by-row basis in Reporting Services

Andrew — Thu, 16 May 2013 17:56:35 GMT

This solution is incomplete and as stated simply does not work.

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

skeltech — Mon, 13 May 2013 20:45:41 GMT

...and this tip is still valid today! Thank you.

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

Gerhard Bosma — Thu, 07 Mar 2013 10:33:38 GMT

@Kevin Fairchild: could you please indicate how to do this in the new (I presume 2012) SQL Server?

re: Microsoft acquires Dundas’s data visualization components, SQL 2008 news & download CTP3!

haarpbot — Sun, 24 Feb 2013 07:20:02 GMT

One thing I really like about the Data Dynamics products is that their APIs all have the same look and feel, so once you learn one, you can easily work with the others. Plus the components expose a lot of APIs, which gives us plenty of flexibility and makes them highly extensible. Using the exposed APIs, we can create applications that make it easy for end users to tailor queries and reports to get the data they need.

www.reportingsoftware.info/.../enterprise-reporting-software-what-is-your-color-of-success

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

Bradley Teague — Fri, 22 Feb 2013 15:26:05 GMT

I'm using the "set Include Report to invalid value (e.g. 0) to effectively cause the subscription to throw an error if no data is available based on a query that counts the rows returned" method.

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

Kevin Fairchild — Wed, 20 Feb 2013 14:57:01 GMT

They did add the option -- it's called "upgrade your edition of SQL Server".

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

Pathetic Microsoft — Thu, 24 Jan 2013 01:45:23 GMT

Why didn't Microsoft just add a checkbox to the subscription to indicate whether or not to send the report if it contains no data?

re: How do you set “(Select All)” as the default for multi-value parameters in Reporting Services?

Karel — Sun, 20 Jan 2013 14:54:37 GMT

Thanks so much!!!!

You saved my google time!!!! Thanks. :-)

re: Fun displaying SSRS (integrated) reports using PerformancePoint SQL Server Report viewer

BIBoingo — Thu, 25 Oct 2012 21:10:56 GMT

If you can't get the ReportServer URL to work. Open Management Services, connect to the SP integrated RS instance. Right click the Server and look at the URL it gives you. Plug that into PPS Dashboard Designer.,

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

Rob — Fri, 19 Oct 2012 06:44:58 GMT

I created a Microsoft Connect request for this: connect.microsoft.com/.../768029