You can print all departments into a single PDF or Excel workbook (one department / worksheet) by using a Statement Group. Statement Groups are described in this video:

_________________________
Andrew Bates