|T O P I C R E V I E W
||Posted - 11/29/2019 : 14:48:54
Is there a way to print out a list of the top valued comics in my collection across all titles, say Top 100 or Top 500?
|4 L A T E S T R E P L I E S (Newest First)
||Posted - 11/29/2019 : 18:36:54
Alternately, if you just want a list (and not a report), you can use ComicBase Statistics (F12).
There is a Collction Breakdown by: Price Range that lists the Prin in varous ranges.
You can click on a range and get a Find result for any comics in that range.
||Posted - 11/29/2019 : 18:25:02
For CB 2017
TOP 50 , I.[Title], I.[FullIssue], I.[Price]
I.[Quantity in Stock] >= 1
For the Select, you can add more columns, if needed.
For the Order By, you can add other Columns (i.e. Title), if needed.
||Posted - 11/29/2019 : 17:22:13
ComicBase 2017 Archive 19.4.4 Build 573
I have a Select: Fields Box BLANK
I have a Where Box: Where I put the Quantity >=1
I have a Group by Box BLANK
I have an Order By: Which I put [Price] then DESC
I do not have a Max Results box
When I click to left of Advanced Find it shows
Just ordered 2020 version today, maybe will have the Max Results Box
||Posted - 11/29/2019 : 15:51:31
You don't mention what edition of CB you have, but if you have access to Advanced Find you can:
Start a Find (CTRL + F is one way).
Using the Find drop-down box, select Advanced Find
In the Items Where... box put: I.[QtyInStock] >= 1
In the Order By box put: I.[Price] DESC
(This assumes Price is the column you want the Top x for)
Change the Max Results box to what you want (100, 50, etc.).
Click the Find button.
This will bring back a result of the Top x issues you own with the highest value.
(note: if many comics have the same value around the max number, you will only get as many as will fit in the number you specified. i.e. #48 is $10.00, 49 is $9.50, 50 is $9.50, 51 is $9.50, 52 is $9.50, 53 is $9.00 will only display 49 and 50 will be displayed but 51 and 52 (despite the same values) would not be displayed)
Select All rows (CTRL + A) and do a Quick Change to set Marked to Checked.
Run a Report that includes a List Only Marked Issues option (Collection Report, Items Checklists, and Price List are probably the best options to choose from).
Checking the List Only Marked Issues will just include the Top x Issues you just Marked with a Check.
Now, if you want a Report