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

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

DateTime Format in Report Builder’s Report Model

Wednesday, March 11, 2009

I created a Report Model based on a relational DB. I used the autogenerate option. I came to show it to my user, and he noticed that one of the attributes showed just the date, without any time. I looked at the field in my DB and saw that indeed it was of type DateTime and had data about time in it as well as the date. Looking at the format Report Model automatically gave the attribute, I saw the format was “d”. I remembered that usually I could copy the format I wanted for a field from the...
5 comments

Filtering a Parameter with a Long List of Values in SSRS

Monday, March 9, 2009

Filtering a Parameter with a Long List of Values in SSRS I've been developing quite a few reports in Reporting Services lately (as you may have noticed from the blog). While showing one of the reports to my user, my user asked me to field he wanted me to add to the report had a very long list of values to it. Reporting Services gives parameters only the option of a drop down list. I knew that using a drop down list on a field which had so many values in it would mean that my user most of the...
7 comments

Showing the header in a SSRS Report without overlapping

Thursday, February 26, 2009

I created a report for my user in Reporting Services 2005. The report was a very simple matrix, but the problem I had with its header could have just as easily existed in a table. Having a lot of rows and columns in the matrix meant though that when my user would scroll through the matrix, he couldn't see the headers for the columns and rows. So obviously I had forgotten something... I went into the matrix properties and went to its Groups tab: I entered each and every one of the groups and defined that the Group's header would...
2 comments

Creating Sum for a Group with Recursion in SSRS

Monday, December 1, 2008

Creating Sum for a Group with Recursion in SSRS  Sum with scope A colleague of mine from work was creating a report with Reporting Services 2005. He had a matrix report like the following:    Year Total Total Sales Per Year % of Sales from the Total Sale Per Status Status     1 Total 2   3He wanted to calculate the percent of total for that year from the total for that row. I remembered from looking at the Sum function in SSRS that it had 3 options – with scope and recursion. So I thought – I should try the scope. And indeed, scope enables you to define a sum...

Intelligencia – for your SSRS reports on an SSAS cube

Friday, November 7, 2008

I wrote a post a while back about the pros and cons of developing a Report Model based on a cube. I got two comments on it telling me to check out Intelligencia. I decided to look into it, and what can I say? I'm impressed... Intelligencia is an add - in to Visual Studio which helps you build Reporting Services Reports on top of a cube. Those of you who have tried doing that in the past with what there is, probably remember that it wasn't terribly comfortable all of the time... First example that goes to mind? Creating...

Report Builder 2.0 RC1

Tuesday, August 26, 2008

My favorite "toy" in SQL Server 2008 just got a brand new spanking release! Report Builder 2.0 just went RC1 after it didn't appear in the feature pack of SQL Server 2008 RTM. When I tried it out first, as a Report Designer Preview in CTP6, I loved it so much that I even decided to make a webcast out of it (both in Hebrew and in English).  Later, I found out this would become the "next generation" of Report Builder. When I downloaded the feature pack that came with SQL Server 2008 RC0 I admit I was a...

Creating a Report Model based on an Analysis Cube – Pros and Cons

Thursday, May 15, 2008

Creating a Report Model based on an Analysis Cube – Pros and Cons If you follow my blog, you probably know by now that I developed a report model based on the Analysis Services cube I already had. I even got around to updating the report model. And then, my users started using it. And you know, whatever we do just seems so wonderful to us, until our users find all sorts of flaws with what we did… so yes, my users did open my eyes to...

Inheritance in Report Model

Friday, May 2, 2008

I recently finished defining and refining a report model based on a relational database. At first, I just set up my DSV and then added a report model with the “Autogenerate” option. Then came the grueling task of refining the report model that was generated… I was using the MSDN pages which were very helpful on that subject, but it’d be fair to say that I something to add to what they suggest for inheritance. See, I was using the inheritance property for my entity and deployed my model to the server. Only thing, when I viewed my...