Frequently, I am required to design SSRS reports that include 4 or 5 small, related matrices and display them on separate pages by date according to the user-selected date range - usually the previous work week.
I need the same matrices to run on each new page with results for the next date in the range.
Is there a way to do this efficiently?
Now, I design one set of matrices, setting a page break after the last of them, copying and pasting them down the body of the report until there are five sets - one set per weekday.
(I have set parameters for setting the date range @BeginDate and @EndDate with defaults for previous Monday and previous Friday.)
Then, I set filters on all of the matrices by an expression to get the desired date.
The clicking and dragging should be easy but getting them in the exact, desired places has caused all sorts of frustration.
I'm a seasoned user of SSRS, and I really think I may be missing something. There must be an easier way.