Browse by Tags

Stop Reporting Services (SSRS) 2008 from overwriting custom Parameter Datasets

Frustrating little quirk when building reports in SSRS 2008 using Visual Studio 2008. If you write a custom query against a parameter dataset, and then change a query that references the parameter, the custom query used by the parameter is overwritten and reset to the default. Now, you could keep...

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 11-16-2009
Creating a Custom Gemini/PowerPivot Data Feed – Method 1 – ADO.NET Data Services

There are already a few good Gemini/PowerPivot blogs that provide an introduction into what it is and does so there is no need for repetition. What I haven’t seen are examples of how existing investments can be harnessed for Gemini/PowerPivot based self-service analytics. This series of posts focuses...

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 10-20-2009
HACK: Exposing Foreign Keys as Properties through the ADO.NET Entity Framework

First post for months; the PerformancePoint Planning announcement forced some redirection and rebuilding. We’ve grieved, we’ve moaned, but at some point, you just have to move on. ----------------- I’m not a fan of hacks – it normally means you are doing something wrong, but in this case, where...

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 10-16-2009
Win\Loss Graphs in Reporting Services 2008

As I mentioned previously , SSRS 2008 allows us to use some nice visualisation techniques in our reports. Win\Loss graphs are used to show (wait for it......) the trend of wins and losses over time. The usual example is the performance of a sports team during a season, but they are also useful...

Posted to Tim Kent's blog (Weblog) by Tim Kent on 02-11-2009
How to: Bullet Charts in Reporting Services 2008

Unlike SSRS 2005 where creating bullet graph takes a bit of jiggery-pokery , Reporting Services 2008 almost has them built-in (thanks the the acquisition of Dundas technology). I say almost as it's actually using a linear gauge object which in the wrong hands allows you to put the likes of...

Posted to Tim Kent's blog (Weblog) by Tim Kent on 01-21-2009
Adventure Works Samples Update and FILESTREAM

A bit late (released at the beginning of the month), but a follow up to post I made earlier this year, there is a new release of the Adventure Works Databases. These can now be found here . They are simplified into just 4 downloads, which makes things a lot easier! Also the install is a lot...

Posted to Martyn Bullerwell's blog (Weblog) by Martyn Bullerwell on 11-30-2008
PerformancePoint Server SP2

A good few months ago I wrote about SP1 for PerformancePoint and getting this working on SQL Server 2008. There were a number of attempts, and with a great deal of hacking, I got an untested environment set up, however this was not very stable and never fully tested. SP2 is due for release...

Posted to Martyn Bullerwell's blog (Weblog) by Martyn Bullerwell on 11-12-2008
Reporting Services 2008 - Connection Problems

Having recently rebuilt a server entirely with "2008" technology I have a small problem with reporting services. When trying to look at the Reports, I received the error: "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel...

Posted to Martyn Bullerwell's blog (Weblog) by Martyn Bullerwell on 07-31-2008
PPS SP1 and SQL Server 2008 RC0

So, one of my previous posts I explored using PPS with SQL 2008 Feb CTP. Now with the release of PPS SP1 and SQL RC0, I thought a perfect time to re-test the installation. With a complete new installation of Windows Server 2008, SQL 2008 RC0, and PPS SP1, the testing has started all over...

Posted to Martyn Bullerwell's blog (Weblog) by Martyn Bullerwell on 06-29-2008
SQL 2008 Feature Pack

Not so much a Pack, as a collection of very useful tools, that can be downloaded here: http://www.microsoft.com/downloads/details.aspx?FamilyId=D68DE3C9-60A9-49C9-A28C-5C46BBC3356F&displaylang=en I will be investigating the Reporting Services Integration with MOSS 2007 very soon, but for the time...

Posted to Martyn Bullerwell's blog (Weblog) by Martyn Bullerwell on 03-31-2008

Page 1 of 2 (14 items) 1 2 Next >