Printed list of all books CKO
Book Scheme - Reports
If you would like to print a single sheet for each student to use as a checklist of all items allocated to them, then from the home screen click on the Reports button and then under Guided Reports select Use Saved.
There are 2 Saved Reports that you can use to generate the report,
Current Loans by Roll Class or Current Loans by Year Group.
When you Run the report and the results are displayed, click on the Download button at the top of the report and then select Comma separated text (csv).
When the csv file is created, open it in Excel and follow the instructions below.
1. Some of the columns will not be wide enough to view the contens so click on the top left between the row and column to select everything
2. Then position the cursor between Columns A and B so that it looks like a cross and double-click to widen the columns
3. If the barcode still looks odd, click on "D" to highlight the column
8. In the Subtotal dialog:
At each change in: Firstname
Use function: Count
Add subtotal to: Tick Title
Tick ‘Replace current subtotals’ at the bottom.
Tick ‘Page break between groups’ at the bottom.
Tick ‘Summary below data’ at the bottom.
9. Click OK
Now when you print the file you will get the details for each student on a separate page.