OfficeWriter v8 for SSRS

Wednesday, April 4, 2012

SoftArtisans have approached me to write a review about OfficeWriter v8 integration with SSRS. Your first question would be: what's OfficeWriter? :) OfficeWriter is an application that works with Reporting Services in two ways: 1. It Allows you to design a report in Word or Excel and render it to an RDL 2. It allows you to take data from an RDL report and use it in a Word or Excel document I believe just those two point hold within them quite a lot, but we'll get to that shortly. I decided to try my hand at creating a report on Adventure Works data: I...

The pros and cons of Report Builder 3.0 over Report Builder 1.0

Thursday, March 17, 2011

So yes, I'm still thinking about RB 1.0 vs. RB 3.0. We've made the move a few months ago from SQL Server 2005 to SQL Server 2008 R2. Most of our projects in the team, if they're not cubes, are Report Builder 1.0 models.  I was really looking forward to seeing how we can move our users from Report Builder 1.0 to Report Builder 3.0. My conclusion? Except for a few very specific cases - we can't.We actually still have Report Builder 1.0 as a click once application from our Report Portal of 2008 R2 and not Report Builder...

Error Message When Using a New Feature in SSRS 2008 R2

Tuesday, January 4, 2011

We installed SQL Server 2008 R2 about 2 months ago, and I recently tried to use a new feature in Reporting Services 2008 R2. I used the Business Intelligence Development Studio (BIDS) to open a new Report Server Project. After creating a data source I also defined a shared dataset (a new feature to SSRS 2008 R2). I put some of the fields into a table and tried to run the report (still inside the BIDS).  But I failed with an error: The report preview failed because the report could not be built. Read the errors, warnings and messages in...

Building Effective data visualizations in Reporting Services 2008 R2

Monday, November 29, 2010

This is a live post from the session of Ronen Chen at Tech Ed Israel 2010 . New to report builder 3.0 - we can be in local mode or server mode. We can check it in relation to performance on the server and save in directly on the server (rather than on my PC). Zooming and moving my map is only possible during the design of the report. We cannot zoom in on it after running the report. A zoom in is possible through an action in the report which will create the zoom in a new report. Avoid...

Microsoft SQL Server 2008 R2 Feature Pack Download

Wednesday, May 12, 2010

Hot off the press!  I just read on Teo Lachev's blog that Microsoft SQL Server 2008 R2 Feature Pack RTM - ed. Yeah, I know! I have to admit this is also slightly amusing for me, as just this morning I asked a Microsoft consultant if he knew when it's suppose to drop...So you know what this means, you can now download a standalone version of Report Builder 3.0, PowerPivot for Excel and Data Mining Add-ins for Office 2007. Each can be downloaded by itself or as a whole package. If you're looking to check out all the new...

SQL Server 2008 R2 November CTP

Wednesday, November 11, 2009

Microsoft just released SQL Server 2008 R2 November CTP. The November CTP is "feature complete" so this should be close to the real thing, before they ship SQL Server 2008 R2 in 2010. I guess you could tell from the news coming from PASS that this would be in the wings. First of all, there was word that the next CTP would be delivered during November (which translates to: now!) and secondly, projects that before would be code named - now have their formal name. Madison is now Parallel Data Warehouse and boasts scalability for the 100+ terabyte DWH...