I have a report that has a page break at group level (person). I've just received a request to amend the report so that it has another group level (department) now so that we can get overall stats per department.
I want the report to initially just display the department and person without person detail so I've set visibility on the detail row group to be hidden with a toggle on the department name (as they will either want it printed in expanded form with detail row group details or summarised by person by department).
The problem I'm getting is that the page break is still being applied at person level so I get a page with one person line on it irrespective of which department they're in. I only want the page break by person if the report has the detail row group expanded. Is there a way of only applying page breaks on whether a group's detail has been expanded please?
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed