Jump to content

Carl Brockman

Members
  • Posts

    2
  • Joined

  • Last visited

  • Days Won

    10

Everything posted by Carl Brockman

  1. What you can do while waiting for a change to the "reporting segment" of CoinManage The following example should work for any Country Start a new Collection and name it: Face Value In the upper left-hand corner of the program right-click on File or the Icon below to Add a New Coin to your Collection Select a Country : United States Select a Denomination : 1 Cent Select a Type : Lincoln (any Type will work under Denomination) Select any year : 1940 Select a Condition : Use the grade Poor (no automatic value will be entered by the program) Enter a Quantity : Example (1565) Enter a Cost : Example ( .01) Face value of the individual Coin Close the Dialog Box by right-clicking on OK. At the bottom right-hand area of the program you should find the total number of Items, 1565 with a Total Cost (face Value) of $15.65 and a Total Value of $15.65. Continue this process with your other denominations. When Collection is highlighted all of your coins are accounted for and the Total Cost is shown. When you open your Collection and highlight an individual Denomination, the information in the bottom right-hand corner will reflect only quantity and cost for that entry. To produce a report, highlight your Collection" Face Value" and right-click on it. Next right-click on Output Report Using....... In the dialog box that appears, go to the bottom of the listing and select (right-click) Coins - SummaryBy Type .lst, and then right-click on Open. When the next dialog box opens right-click on the "upside down pyramid"(left of the Options Button) and then right-click on Preview and then Start. If you are satisfied with the report repeat the process and print it this time. I hope this was helpful and my apologies if the level of detail offended you.
  2. I have submitted this information to Mr.Dembowski several times and have not yet seen these problems resolved. Under the heading "Reporting" you have provided several premade reports to select from. All the reports may be modified using the Edit Report… feature. That works fine with the exception of Sorting further discussed below. Under Create Collection Report… a dialog box (similar to Print Preview) appears offering several selections. Under Grouping and Sorting Options, you have 12 selections under Sort By: and 7 selections under Group By. Whatever you select in Sort By: or Group By: they default to each other. You only get one selection. Edit Report…allows you a Sorting option dialog box with several choices including the standard Country > Denomination > Type > Year sort. There is no flexibility for the user to add or modify this area for other combinations. The dialog box that appears infers that you can select one or more sorting options from the left pane and arrange them in the right pane to suit your sorting requirements, however it will not work for me. I save the new or edited report and go back to view it in "Preview" and a dialog box appears with an error message (TO FEW PARAMETERS. EXPECTED 1). The only combination that will work is your Standard Sorting, listed in the first sentence of this paragraph. My 2015,2016 and 2017 CoinManage Deluxe programs (downloaded from the internet) will only allow me to sort on one column of information (year, type, denomination, ect.) or a standard, Country > Denomination > Type > Year. Sorting by Type and then by Year has an inherent problem of displaying incorrectly in any report. Example: United States 50 cent’s have ten individual entries, to name a few (Flowing Hair 1774-1795; Barber 1892-1915; Walking Liberty 1916-1947; Kennedy1964-to present. The sorting by TYPE is alphabetical displaying the report in this order….Barber, Flowing Hair, Kennedy and Walking Liberty. This is annoying and unsatisfactory to me. Perhaps you can modify the program to correct this situation. Delete "Type" in the standard sort order. If Type is a field in any report, it will naturally appear with the year(s) it is associated with. However, at the user’s level there is a work-around to solve this problem. Simply stated, when sorting a field in "MS Access"( the base of this program), it first look’s for Spaces, then Numbers and then Letters. Go to Tools and open the Coin Database Editor. Select your Country, Denomination, and Type. In the area "Type Name:" is where you would enter your “spacebar” character(s). Adding a space(s) causes the sorting process to look at these names first, arrange them by number of space characters, and then alphabetically, and move them to the beginning of the listing. The sorting continues arranging the balance of the listing in alphabetical order. When viewing your collection you will notice under Type this “space” misalignment. However, all of this effort is lost when applying a program update or reloading the existing program. To me this would be an appropriate chronological sort.... Country > Denomination >Year >Mint.
×
×
  • Create New...