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:
Friday, October 23, 2009
I read a few months back a post by Robert Bruckner saying that the InScope function isn't relevant anymore, when you’re creating a report with Tablix.
I remembered that when I wrote about a recursive sum for a group in a matrix in SSRS my example was only about SSRS 2005, as my VPC with SSRS 2008 crashed… well I finally downloaded SSRS 2008 R2 and installed it. So what did I do (after checking out the new maps feature)? Well, I wanted to see how simple creating a recursive sum in a matrix had actually become. I created...
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...
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:
Total Sales Per Year
% of Sales from the Total Sale Per Status
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...