[Evergreen-reports] Dewey Tens Call Number Report with Null Values

[Jessica Venturo]

Hi all,

A librarian in our consortium has requested a report that shows circulation
by Dewey ten blocks, filtered by check out date range, the library where
the item was checked out, and owning library of the item.  The template was
easy to assemble using the Classic Circulation source. However, they have
recently requested that the report list ALL of the Dewey ten blocks - not
just the ones that had circulations within the given time period.  In other
words, they would like those Dewey blocks from which no items circulated to
display in the report with a value of "0."  I had originally thought to use
the Classic Item Source and rebuild the template, but alas, it does not
seem that there is a link to the circulation table from that source.  I am
hoping that someone with more experience with nullabilty than me can give
me some pointers on how to alter my original template so that it displays
the information this way (if it's possible).

The display field that I'm using are:
Classic Circulation View > Dewey  Block - Tens (Transform - Raw Data)
Classic Circulation View > Circulation (ID, Transform - Count)

The filters I'm using are:
Classic Circulation View > Library Circulation Link (Transform - Raw Data,
Operator - In List)
Classic Circulation View > Copy Link > Circulating Library (Transfom - Raw
Data, Operator - In List)
Classic Circulation View > Circulation Date/Time (Transform - Date,
Operator - Between)

Any help you can give would be appreciated!

Thanks,
Jessica

-- 
Jessica Venturo
Applications Support Specialist
Bibliomation, Inc.
24 Wooster Ave.
Waterbury, CT 06708
203-577-4070 x105
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20140429/de2b3c4f/attachment.html>