Referencing calculations in different parts of your report

Monday, January 13, 2014

I’ve recently found something new to use in SSRS. Yes, 7 years of usage and I found something that was completely new to me. And then I discovered it existed since SSRS 2008 and I just hadn’t used it (oops!). I was a bit hesitant of posting about it, until I also heard a lecture about it in the last BI User Group meeting (and I recommend you go to meetings taking place around your neck of the woods). So now I feel very comfortable in telling you about referencing calculations in different parts of your report through the...
tags: ,
no comments

Report fields not showing correctly in Report Server

Sunday, December 8, 2013

I’ve created a report quite a while back ago in SSRS for my client and deployed it to the report server. He used the report regularly (and I should know as much because I got requests for changes). Suddenly one day he sends me an email with a screen shot of the report with one of the fields showing a complete blank. I couldn’t understand why. I looked the report up in BIDS and the fields showed correctly. Looking at report on the server still showed me the field as blank. I was completely baffled. I decided to delete...
no comments

Power View on SSAS Multidimensional

Tuesday, December 11, 2012

Microsoft recently released a CTP of Power View on SSAS Multidimensional, (and yes, I know I'm a bit late writing about this, but I still wanted to give my two cents on it). So we're edging closer towards the point where Power View and Excel will be able to cover all of your viewer needs (or at least most of them :)). Years ago when I wrote about Report Builder on a cube and all the problems that that relationship created, I wondered when that would be fixed. Now that we have Power View, I'm glad that Microsoft is...
no comments

A Comparison between SQL Server 2012 BI Tools

Saturday, July 28, 2012

I have recently posted an article in Silicon India comparing SQL Server 2012 BI tools and means of development. I addressed there the tools in SQL Server 2012: SSRS, Report Builder 3.0, Power View, Tabular and Multidimensional Analysis Services.Though I tried to cover much ground in the article, I would still recommend some additional reading: A short comparison between Tabular mode vs. PowerPivot A more detailed comparison between Tabular mode vs. PowerPivot vs. Multidimensional SSAS ...

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...

How to not add another table to your DB (by using Excel!)

Friday, May 13, 2011

Hey blog, how are you? I know I haven't been here for quite some time now... I guess I needed a break. Some time for myself. And I know you were waiting here for me all that time. Being patient and understanding. Knowing that one day, I'll come back. Thank you. I missed you. I think this time, I'm here to stay. So, the topic for today is how to not work automatically and adding a table to your database. About a year ago, I created a report in SSRS for a user of mine on the distribution of workers...
tags: , ,

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...

Using the Dallas Project in Excel and an SSRS Report

Monday, December 7, 2009

I read a while ago in Chris Webb's blog about project Dallas which really got me interested. Quoting from the site itself: "Microsoft® Codename "Dallas" is a new service allowing developers and information workers to easily discover, purchase and manage premium data subscriptions in the Windows Azure platform." So what does it mean? Basically that you have a public data source in the cloud that you can connect to and use for your own applications. And why am I so psyched about this? I have to admit that I am constantly looking for data I can use for demos....

Performance Point integration in SharePoint 2010

Monday, November 2, 2009

Microsoft had released not too long ago, the last Service Pack for the standalone version of PerformancePoint Services - PerformancePoint Server 2007 SP3. From here on out, all development for PPS is going to be part of SharePoint Server. This is again part of Microsoft's strategy of empowering SharePoint as a product, as it also connects to Excel Services, Reporting Services (including Report Builder) and Visio Services.So what's new to PerformancePoint 2010? SharePoint Server 2010 as the repository - meaning PerformancePoint Services stores data sources in document libraries and all other dashboard content in lists. PerformancePoint Services uses SharePoint Server 2010...

Recursive Sum for a Group in a Matrix in SSRS

Wednesday, April 22, 2009

Recursive Sum for a Group in a Matrix in SSRSI wrote a post not too long ago about creating Sum for a Group with Recursion in SSRS. A reader of that post dropped me a line as she was having trouble recreating the same behavior in a matrix (the post itself had demonstrations in it only for a table). So I decided to look into how a recursive sum acts in a matrix, and boy what a learning experience that turned out to be...I created a report with a matrix which connected to Adventure Works DW. I defined the...