Custom reports are generated by a two step process:
- select the columns on the custom report page
- select the rows on the product list page
1. Go to the custom report page
Go to Data exchange > Custom reports ⤴
2. Create a new report
Click the Add button.
Fill in a name for your report. If you want to be the only person who can see your report, tick ‘Make private’.
Click Save and continue editing
3. Configure your report
Click Add columns to add columns to your report. Every available column for a product report is listed. Tick the columns you want to include, or fill in the filter to search for a column or columns (e.g. ‘isbn’).
Click Save
The columns you have selected are displayed. Drag and drop a column to change the order it will appear on your report. You can add or remove columns at any time.
The page you are configuring defines the columns of your spreadsheet, but does not populate the rows. To confirm the selected columns are as expected, click Export sample to Excel to populate with some randomly selected records.
4. Populate the report
Select products to run the report on. You can do this using a search, or by selecting products on the products page.
Using a search
Go to Searches ⤴, and search to narrow down your selection (e.g. within a range of publication dates).
Click Batch actions > Exports > Run custom report. Choose the name of the custom report you created above.
Click Run custom report.
Your report runs in the background. Go to Notifications ⤴ to retrieve your report.
Using the products page
Go to Bibliographic > Products ⤴, and search to narrow down your selection (e.g. within a range of publication dates).
Make your selection by ticking the boxes. Click the top box once to select everything on that page. Click the top box twice to select everything on all pages.
Click Run custom report.
Choose the name of the custom report you created above. Click Save.
Your report runs in the background. Go to Notifications ⤴ to retrieve your report.