Changes between Version 8 and Version 9 of reportsTutorial


Ignore:
Timestamp:
Sep 27, 2009, 10:28:46 AM (13 years ago)
Author:
risard
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • reportsTutorial

    v8 v9  
    3838=== Avoid the data type "link" and "id" ===
    3939These fields are database specific and won't return what you think they will.  Selecting id from "Call Number/Volume ID" will not retrieve call numbers but rather a list of integers used by the db to keep track of call numbers in the system.  It may seem like listing ID and link fields at all just adds to the complexity of the report generator, but they're very useful for the db administrator.
     40
     41----
     42=== Barcodes might look strange in an Excel Spreadsheet ===
     43This is because MS Excel represents long numbers as exponents.  You can fix it by formatting the barcode column as "Number" with zero decimal points.  Alternatively, you could just use the Open Office spread sheet program called Calc.  It represents the barcodes accurately without having to make changes.  It can generate almost any report Excel can and it's a free download.