Browse by Tags
All Tags »
SSRS (
RSS)
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 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
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...
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...
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...
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...
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...
Recursive Sum for a Group in a Matrix in SSRS I 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...
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 format...
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...
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...
I've recently created a Report Model with a Lookup Entity in it. I saw to it that I had only one default detail attribute for it, and I gave that attribute a ValueSelection of list. When I used the Report Model, I saw the attribute fine (as if it was inside the main Entity) but when I tried to filter on it I saw the Lookup Entity I was trying to hide and a filtered list. I couldn't understand why that was. I went back to check the attribute. Its ValueSelection was of type list. I went to...
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 3 He 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...
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...
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...
More Posts
Next page »