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

[Elisabeth Keppler]

This may be naive, but the only way I've found to get  "0" values included
is to submit a report with a Pivot Label Column defined.  When the output
is in table form instead of a list, the "0"s appear.

Thanks,
Lise


On Tue, Apr 29, 2014 at 5:24 PM, Jessica Venturo <jventuro at biblio.org>wrote:

> 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
>
> _______________________________________________
> Evergreen-reports mailing list
> Evergreen-reports at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports
>
>


-- 
Lise Keppler
Forsyth County Public Library
660 W 5th St
Winston Salem NC 27101
336-703-3070
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20140429/2bdd5d3a/attachment.html>