I have a pivot table based on payroll data. In some weeks not all the departments within a particular payroll has any data so does not show up on the pivot table (which is good). However when I run the report, which is looped on Department, it shows a page for every department regardless of whether there is any data. It just has the table headers. How can I stop this??
