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