Create a custom report using Report Viewer
Start with a default report, choose the specific data you want to see, and save your new report for easy retrieval.
What to do next:
Note: To add a report to your favorites list, select Favorites
in the top-right corner and then select Add this report to favorites.

Export reports using Report Viewer
You can export your custom reports to multiple formats.
Remove duplicate values when exporting an Inventory Report to Microsoft Excel
Important: The following is not an official recommendation.
For more information, see the Microsoft Office website.
- In Microsoft Excel, on the Data tab, in the Data Tools group, select Remove Duplicates.
- Select the Columns with the duplicates you want to remove.
- Select OK.