SQL Server 2005 Report Builder webcast

I recently became aware of the following webcast about Report Builder, the framework for ad-hoc reporting in SQL Server 2005 (Yukon).   TechNet Webcast: End-user, Ad Hoc Reporting in SQL Server 2005 Reporting Services   To my knowledge, Report Builder is based on the ActiveViews technology that MS purchased in Spring ’04.   I haven’t…

4

TIP: Displaying images created using RenderStream

I’m working on an application that uses the Render() and RenderStream() methods of the SRS ReportingService interface. This app is an ASP.NET WebForm that calls Render() for a given report (and RenderStream if the report contains stream resources – images, charts, etc), gets the results back as HTML, and outputs the HTML inline in the…

2

TIP: Moving Reporting Servers between domains

  I recently had to move some development SRS machines from one domain to another at work. This consisted of two cluster web boxes, and one SQL Server, using SQL auth.   After doing so, I received the following error:   Reporting Services Error The report server cannot open a connection to the report server…

7

Emerging from the darkness

I haven’t posted for a month or so; I was on vacation for a couple of weeks, then spent most of last week in class. As a result, I’ve been pretty buried in catch-up work. I hope to get back into the swing of things more actively in the near future. I’m looking forward to…

0

A few interesting local-search tools

I’m sure most blog-readers are now familiar with Lookout, the local search tool that integrates into Outlook (recently acquired by Microsoft). Lookout builds a local index of your Outlook mail store, and provides a search interface into that index. I’ve been using it for a few months, and find it exceptionally useful; it’s fast (no…

2

searching …

As I mentioned in my initial entry, quite a bit of my MS employment history was as a Development Manager; this included MSDN Online, Technet Online, brief stint as owner of the Microsoft.com Download Center, and search.microsoft.com. My experience with search was a difficult time for many reasons, but it was a great experience; it…

2

Conditional display of Subreport

My current reporting project includes a requirement for daily / weekly / monthly view of distribution and recurrence of user visits to Microsoft.com. The displayed data will differ based on the date period used, so I decided to use multiple subreports within the main report, showing a different one based on the date period.  …

1

Finding the right item with FindItems

I have recently been developing against the SRS web service API, and have noticed a few peculiar things about its design. One in particular is the difference in behavior between ListChildren and FindItems. Both of these methods take a parent path parameter (among others; see the links above for complete signatures) and return a CatalogItem[]…

0

first post!

Oh, wait a minute. This isn’t slashdot. Regardless, this is my first post on my shiny new blog. Who: I’m Stuart Updegrave; I work as a developer in the Business Intelligence team for Microsoft.com. I’ve been working at Microsoft for over 7 years now, as a Web Developer, Dev Manager and most recently SDE. I consider…

4