I think a fairly simple question, but I wonder how to do it in SSRS 2008 R2:
I have a table with recruitments and exits for personnel per week. Apart from that I have a starting value for the number of employees at the beginning of a year from another table.
I would like to have a report per week with a starting value for the no. of employees at that week, the recruitments and exits in that week and an ending value for the no. of employees. So, a matrix with weeks horizontally and starting value, recruitments, exits and ending value vertically. Starting value and ending value per week are calculated in the report (except from the initial starting value).
My point is how to repeat the ending value in a particular week to the starting value in the next week.
Can anybody tell me?