Execute custom view definition.

Click Export Custom View.

In this case Items Never Loaned Out are displayed.

Select Export Format.

Select data fields.

Select export options.

Enter or select an export to file.

The exported file is saved in the C:/handy_lib/data/db/expimp/ folder.

Click on the file to open.

Select the content of the text file.

Copy the selected content.

Paste the content into Excel.

Question:
Could you show me where to find information on what and how the SQL definitions under Custom View Assistant work, specifically the "copies per title" sort process?
My question is how can I design and run reports and export library results to excel spreadsheet.?

Answer:
You can utilize the Firebird SQL language and review our example on implementing view definitions and the export feature.

Question:
Could you please let me know how handy library system can export the loaned items into an excel file?

Answer:
In Custom Views, you can define any SQL query and export the results to a text-formatted file that you can open in Excel. We provide help with SQL queries for users with valid support.