Using SSRS 2008. I have a report that is filtered by Department (dropdown parameter with ability to select multiples). If the user selects multiple or all departments, I need to insert a cover page between each group of departments. ANyone heard of a way to do this?
The easiest solution should be to do the following:
I'm still working on a way to insert a page break following the cover page, but you should be able to get this through trial and error by making the contents of that placeholder long enough (try using CHR(10) to insert numerous line returns) to force the details row to the next page.
If I find a way to insert a page break within the placeholder I'll update my answer. BTW, I tested using CHR(12) which is a form feed and would normally insert a page break but SSRS is not recognizing it as such.
Good luck!