Want List

[Jeff Kolker]

Hello!

 

In the previous version of CB, I could print a report that would list in summary fashion all the books I've marked as "Wanted".  It was fairly concise and I would use it to send to vendors, upon their request, to see if they had anything matching my list. 

The report used was the Collection Report, and worked great.  I would select All titles and it print only wanted items. 

This no longer works.  (I've attached my old one for reference.)

Is there a substitute Want List type report that would list everything marked "wanted' in a nice, neat, concise report?  I was told I could use a spreadsheet, and have and attached one that was created.  Seems unwieldy.  And not something I would want to send to a vendor.  And compared to a report, not as easy to produce.

If there isn't a substitute, I would request one be added.  I think a Want List would be almost a necessity for a collector. 

Thanks,
Jeff

new want list.xlsx jeff's want list.pdf

[Steven L. Dasinger]

Collection Report looks like the correct one, and it does have a List Only Wanted check box, but it does not appear to work (and it should).

I did the same steps of selecting all titles and checking the Wanted Items check box but it doesn't find anything.

A normal find on field Wanted, however, does return the rows.

[Jeff Kolker]

Quote

A normal find on field Wanted, however, does return the rows.

Yes, that's how you get the spreadsheet.  You do a search for "wanted" and then select all the records that appear, Ctrl-C to copy and then paste into the spreadsheet.   As you can see from my attached spreadsheet, not the most visually appealing result.  I know I could spend time making it look nicer, but would have to do it each time the want list was updated.

In the past I had received nice comments about the want list I sent them... not sure what they would say about the spreadsheet.

[Edward G. Guetzow]

I just ran this report on my system and it worked.  You might be forgetting to select the option that states "Selected titles".  If you leave it as the default "Titles I Own" it will not find any issues.

When you choose "Selected Titles" then click "choose " and at the top of the next screen click on "All Titles" or "Titles in stock".  Then highlight all issues that you have wants for and then "Ok".  You MUST highlight at least 1 title.

Selecting print will send the file to be saved wherever you wish.  You can then open the file and print it yourself.  It generates  the report like it was before but instead of just printing it, it asks you to save it.  Extra steps!  😞

 

Edited January 5, 2020 by Edward G. Guetzow
Correct grammar.

[Steven L. Dasinger]

That is interesting.  I am using CB 2020 Archive Edition v20.0.1.2847 and when I try to run a Collection Report for Wanted items (the List Only Wanted Items is checked), I get a message "No items were in your collection inventory which matched those criteria" even though I do have them.  Here are the steps I take:

Select the Collection Report from the Reports menu.

Click on Selected Titles, then the Choose button.

Click on the Titles in Stock, and then high-light a Title that I have at least one Item # with the Wanted field checked and click okay.

Back at the Collection Report window, I now have 1 Chosen next to Selected Titles.

I have Tried Basic and Summary so it doesn't matter which one is chosen.

I Check the List Only Wanted Items box. (no other box is checked). and the click on Preview.

Since I DO have an Item # that has Wanted in that Title, I should get a report but get the message I mentioned before.

I have gone back and selected Current Title (still a Title with and Item # with Wanted checked), and Titles I own (which has many Titles/Item #s with Wanted Checked) and all get the same message and no report.

I have even used Select Titles and, when Choosing, high-lighted every Title in CB without getting a report.

 

Edward, can you pass on you CB version and exact steps you are taking to get a successful Collection report of Wanted Items, please?

 

[Edward G. Guetzow]

CB version is 2020 Archive Edition v20.0.1.2836.  I have been able to generate the wanted list in 2 ways.  I was mistaken about the first & easiest way as I had not tried it since my last update/upgrade (too lazy).  I had already figured that I could generate a report using the second method.

The first method (which I had not tried again when I last posted):

   Choose Report

   Collection Report - "Titles I Own "

   "List only wanted items"

   Print or Preview.  File is created for export and you are asked to save it.

The second method was the way that I had defaulted to do:

   Choose Report

   Collection Report - "Selected Titles" and click "Select"

   At the new screen, select "All Titles' or "Titles in stock"

   Highlight all the titles that you are interested in finding and press "OK"

   Print or Preview.  File is created for export and you are asked to save it.

Perhaps it is a bug in the current CB version?

Edited January 5, 2020 by Edward G. Guetzow
finish

[Steven L. Dasinger]

Thanks for the information.  It appears to work in 2836 but not in 2847.  I even tried Rebuild Lists and it still doesn't work for me.

Hopefully it is an easy fix when it gets looked into.

[Jeff Kolker]

Does not work in 2764 either...

[Jeff Kolker]

or 2851

[Edward G. Guetzow]

 

I upgraded to build 2851 and both methods work for me.  However, not all of my selected wants are showing in the reports.  It looks like they were not all picked up in my previous build as well (2836).

Also, the file is being exported on my system because I forgot to select a printer for output.  So, selecting output to my printer works correctly.

I am having trouble with file tools as "Optimize Database" and "Rebuild Lists - Item Information" cause the program to crash.

 

[Jeff Kolker]

The ONLY time I get results from the Collection Report is if one is marked "wanted" that I already own.  IF the issue is marked wanted and I don't have it in stock, it does not get picked up.

I can actually get a want list with the Item Checklist.  However, the nature of that report is 1 issue per line.  Thus my report would be 81 pages if printed.  As opposed to the 14 page one from the Collection Report that was in CB2017.

I think a dedicated Want List would be a good addition to CB. 

[Edward G. Guetzow]

I can confirm that ONLY issues that I currently own and are marked wanted will appear on my want list.

[Peter R. Bickford]

I think the problem is that the Collection reports is actually defined as  reporting on items that are in your collection already. The report you likely want to use is an Issue Checklist.

[Jeff Kolker]

I can get a want list via the Item Checklist, but it does produce an extremely long report being that the layout is 1 record per line.

14 pages from the old 2017 Collection report to 81 pages with 2020 Issue Checklist.

Would love to see a dedicated Want List report ... especially in summary form.