<
div class=”ExternalClass16EB91745BFA419384C0E3307E72D388″>
With some guidance from Microsoft TechNet, Edward at StackOverflow.com, and Adam at RedThree, I managed to enhance the Compliance 5 – Computers in a Collection report by separating each computer onto its own page. When exported to Excel, each “page” becomes a worksheet or tab. This could also be separated by any other field in the report such as Computer Domain, SCCM Site, etc.
Start by opening the Compliance 5 – Computers in a Collection report in Report Builder then follow the steps below:
- Click the data row ( point 1)
- right-click on the Row Group name (= (Table0_Details_Group)
- select Add Group
- select Parent Group…
In the Tablix group
- On the Group by drop down, select the column you want to group by. In this example [UpdateClassification] is used
- Select / enable Add group header
In the Row Groups panel
- right-click the column you want to group by. In this example [UpdateClassification] is used
- Select Group Properties…
In the Group Properties
- Select Page Breaks
- Select Between each instance of a group for the Page break options
In the Report Builder main window
- Select the cell that was added for the Group by function
- Enable the Properties View
- Expand Group –> Group –> PageBreak –> PageName
- Select the drop down arrow and <Expression…>
In the Expression window
- Select the Fields (DataSet0) Category
- Double-Click the column you want to group by. In this example [UpdateClassification] is used
[read-more-redirect urltext=”CatapultSystems.com” url=”https://www.catapultsystems.com/blogs/reporting-with-custom-pagination-and-excel-named-worksheets”]
Save the report (as a new name if desired)
- select some parameters and Run the report
- select Export and Excel
Exporting the report to Excel now generates a new tab or worksheet for each Update Classification
The report file (Compliance 5 – Computers in a Collection with pagination.rdl) can be found on my public OneDrive.
[/read-more-redirect]