Scott J. Brown Posted June 7, 2021 Posted June 7, 2021 Looking to generate a report that shows issues with multiple qty across multiple grades. For example the report could generate as follows Title A, Issue 1 has qty 3 NM and qty 1 VF and QTY 2 VG. Title B, issue 7 has qty 17 NM, qty 1 CGC 9.8 Above would be ideal format, especially if I could have "custom field 1" included for each entry as that is the current box location of the issue(s). A report that simply states the following would suffice though. Then I could manually go to each title and write down the box locations. Title A, Issue 1, Qty 6 Title B, Issue 7 Qty 18 Hope this isn't too confusing.
Mark J. Castaneda Posted June 7, 2021 Posted June 7, 2021 If you have our Archive or Professional Editions; use the 'export' option under the File Menu to pick out which fields you want. You can then load the export file into a blank spreadsheet program like Excel were you can customize the report you want.
Scott J. Brown Posted June 10, 2021 Author Posted June 10, 2021 I do have the Archive edition. I don't know how this gets me the report that I want though. I can export all title, item, condition and qty in stock fields and Custom Field 1. But that just gives me a spreadsheet with 9000 lines to sort through. I would have to go through and manually remove the 8500 or whatever lines that I do not want for this particular report. Plus, I would have to manually do this every time I added to the collection.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now