Jeff Abersold Posted January 6, 2021 Share Posted January 6, 2021 Maybe I'm missing something completely obvious (if so, I'm sorry for asking) but can I make the program show me just the items I have in my collection? I do not want to print it, I just want to be able to make changes without having to look issue by issue. Thanks, Jeff Link to comment Share on other sites More sharing options...
Steven L. Dasinger Posted January 6, 2021 Share Posted January 6, 2021 To do this use the View drop-down box in the top left part of the window (under the Menu line) and select Items To Show->Owned Items. This will only go to Titles you have owned items and display only those items. Link to comment Share on other sites More sharing options...
Steven L. Dasinger Posted January 6, 2021 Share Posted January 6, 2021 After going back an re-reading your post, I will point out that you will still have to go Title to Title to see items in them. If you just one big list of all your owned Items, you can do a Find. One way is to use Item Field Qty in Stock and set Greater Than or Equal to 1. Link to comment Share on other sites More sharing options...
Jeff Abersold Posted January 6, 2021 Author Share Posted January 6, 2021 Thanks so much Steven. Link to comment Share on other sites More sharing options...
Jeff Abersold Posted January 6, 2021 Author Share Posted January 6, 2021 After giving your suggestions a try they don't do exactly what I was hoping. I basically want the grid view for everything I own instead of just a certain title. Link to comment Share on other sites More sharing options...
Steven L. Dasinger Posted January 6, 2021 Share Posted January 6, 2021 I guess I am still not sure what you are trying to display. The second suggestion (Find for Qty in Stock >= 0) will get a grid view of everything you own in one list that you can scroll through. This sounds like what you are asking for which is why I need a better idea what you want. Link to comment Share on other sites More sharing options...
Jeff Abersold Posted January 6, 2021 Author Share Posted January 6, 2021 Yes, this sounds like what I want, but every time I tried it only showed me issues for whatever title it was previously queued on. Link to comment Share on other sites More sharing options...
Steven L. Dasinger Posted January 6, 2021 Share Posted January 6, 2021 Strange. Try it this way, bring up a Find window (CTRL+F or click the Magnifying glass icon). Select MyComics in the Find drop-down box. Optional (and should be redundant), click the List Only Items In Stock check box in the bottom left corner. When I run this I get a result of all my comics. 1 Link to comment Share on other sites More sharing options...
Jeff Abersold Posted January 6, 2021 Author Share Posted January 6, 2021 Perfect! Link to comment Share on other sites More sharing options...
Steven L. Dasinger Posted January 6, 2021 Share Posted January 6, 2021 One more thing I meant to mention. The black underline I added is under a drop-down box that lest you switch between Views (Books, Comic Books, Magazines). The Find will only work on one View area at a time. So the Find will get you all your Comic Books but not anything in the Books or Magazine View. You can change your View and run the find in each to get a list for each View. Link to comment Share on other sites More sharing options...
Jim Dreyfuss Posted February 20, 2021 Share Posted February 20, 2021 Hi Steven, maybe you can help explain a variance I am seeing. If I go to Report > Collection Report > Titles I own > Summary > Preview, I obtain a Report that lists each unique comic I own, along with the "Total Comics" and "Total Value" on the last page. If I go to what you describe above; Items > Find > "My Comics" > "List only items in stock", I get a completely different value that in my case is lower by nearly 300 comics and the value much lower when I move the 2 pages to an Excel Spreadsheet and look at the total number of line items and the sum of the individual values. Any idea why the discrepancy? Thanks! Link to comment Share on other sites More sharing options...
Steven L. Dasinger Posted February 20, 2021 Share Posted February 20, 2021 Since I can't see your database, I checked to see what mine has. Collection Statistics 20,855 Comics (total) and 20,452 Unique Collection Report 20,855 Total Find Qty in Stock > 0 20,452 issues (I don't have separate issues for duplicates, so this is the Unique issue count) Total Cost, Total Value, and Total Price also (almost) match. The Total Value and Total Price are off by 3 and 5 cents, respectively (probably a rounding error). So, for me, everything matches. Then why are your numbers off? I am not sure. First, make sure to upgrade to the newest release (1577). I was having some problems getting numbers until I did this. Then run a File->File Tools->Rebuild LIsts checking Series Information, and (especially) List of Owned Series (you can check the others but they shouldn't affect what you are having a problem with). After that completes, run an Optimize Database (because it can't hurt...). Next, Make sure you are comparing Total to Total and Unique to Unique. By that I mean, the Collection Report returns Total Issues while the Find returns Unique Issues. Next, depends on what you have. Find Where Qty in Stock > 2. check to see if any of there values don't look correct (i.e. you only have 2 of some issues but CB indicates 3 or more). This 'shouldn't' happen but conversions, imports, user error, etc., can get stray incorrect information into the database. (not common but not unheard of). The last thing I can think of (and the least fun...) is to spot check various Titles and see if you can see anything strange (hopefully the Find for Qty in Stock > 2 (or so) will have found this already. Okay, the very last thing is to do a complete inventory of your comics comparing this to CB. Link to comment Share on other sites More sharing options...
Joe V. Gonzalez Posted February 20, 2021 Share Posted February 20, 2021 So I have a related question. Why can I not scroll through my collection using two functions, I would like to have the Titles on "Titles in Stock" and also use the "View" drop down to view "Items to Show" as "Owned Items + Regular Issues"?? It can't use both? It seems that the older version allowed me to view my collection this way, but this new version does not. Can someone clarify or help me if I am doing something wrong? Your help would be greatly appreciated. Link to comment Share on other sites More sharing options...
Steven L. Dasinger Posted February 20, 2021 Share Posted February 20, 2021 Joe, I think I follow what you are wanting (Navigate to only Titles you have at least 1 owned Issue but display all (or at least non-variants) when that Title is displayed. If this is correct, then are are correct in that it can't (currently) be done. The Find Title window list of Titles and the View settings are unrelated (One is just a filtered list to select from and the other is a preference setting for display). I think I remember what you are describing. The navigation arrows (top right corner) used to have some additional functionality where you could right-click on them and select some action (like go to next title without covers) one of which was to display only Titles you owned (going by memory here so I could be mistaken...). You should probably create a thread under Feature Suggestions and mention that you would like the ability to Navigate between only Titles you have one or more Issues and to display only Owned and Regular Issues for those Titles. Link to comment Share on other sites More sharing options...
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