Browse by Tags
All Tags »
Reporting Services (
RSS)
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...
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...
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...
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 quite a few problems that may occur when you build...
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...
Webcast: צעדים ראשונים ב Reporting Services 2008 אני חושבת שהבאזז סביב SQL Server 2008 כבר הדליק את כולנו. אני החלטתי להתחיל ולבדוק את מה שקיים כבר במערכת ודבר ראשון, החלטתי להתחיל עם Reporting Services 2008 . ב Webcast הזה, אני אראה איך בונים דוח בסיסי עם הממשק החדש. View Video קובץ ה WMV להורדה לינקים מהסרטון: לאתר Reporting Services 2008 כאן לפורום של MSDN ישראל לשאלות ותשובות בנושא SQL Server כאן להורדת דוגמאות ל Reporting Services 2008 כאן להורדת הסקריפט בו אני משתמשת בסרטון כאן
Webcast: First Steps in Reporting Services 2008 [EN] I think the buzz around SQL Server 2008 has got us all interested in learning more about the product and what it has to offer. I personnaly, decided to learn first more about Reporting Services 2008 . In this webcast, I'll show you how to work with the new interface and build a basic report. View Video To download the WMV file The links mentioned in the webcast are: The Reporting Services 2008 Site here The MSDN Forum for Q&A on Reporting...
Well I guess congratulations are in order because I finally got around to using a report builder in my project. Turns out that building a report model based on a cube is as easy as 1-2-3. Still I had a problem, as for some unknown reason the translations were showing for my dimension names and my measures, but not for the dimension's attributes... At first I thought maybe this is a problem solved by Service Pack 2 (as my tests were done on a Server with Service Pack 1). Alas, no. So, a further...
Continuing my theme of looking at things in the appropriate place , I thought I'd add another story. I was just building a report in Reporting Service, and defined the TextAlign property of the line to be "right". For some reason, when I previewed the report in the Visual Studio on my pc, in some cells the alignment was left and in some it was right. I found in a few occasions, that when it comes to viewing your report in SSRS, you should define all of your needs in the report and then...
Remember how I taught you to recreate your Analysis Project ? Well, let's say this time you have a model you deployed to the Reporting Services Server, but you have changed it since then and want the old version back. So how would you recreate the model you have on the server? First of all, create a new Data Source View in your Analysis Project. It doesn't have to include all the relevant tables, as you'll only use it as a shell to build upon. After you've finished defining the DSV...